what is limitation /max number of ExecuteNonQuery in c#

Martin Wang 126 Reputation points
2023-07-06T03:26:37.0133333+00:00

i'd like to ask what is limitation /max number of ExecuteNonQuery in c#. thank you

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,216 questions
0 comments No comments
{count} votes

Accepted answer
  1. Jiale Xue - MSFT 48,776 Reputation points Microsoft Vendor
    2023-07-06T05:25:01.2933333+00:00

    Hi @Martin Wang , Welcome to Microsoft Q&A.

    There is no inherent limitation on the maximum number of ExecuteNonQuery calls in C# itself.

    The ExecuteNonQuery method is part of the ADO.NET framework, and its execution is primarily dependent on the underlying database management system (DBMS) being used. The limitations, if any, would be specific to the DBMS and its configuration rather than the C# language or ADO.NET.

    Your next search direction should be to find the limitations of the database you are using.

    Of course it is also affected by the environmental resources you use.

    Best Regards,

    Jiale


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.