Stored Procedure Return
This section demonstrates calling stored procedures with ADO.NET: using ExecuteNonQuery to get the number of affected rows while capturing the stored procedure Return return value 1. Database Stored Procedure Definition …
SqlDataAdapter
C# ADO.NET Call Stored Procedure to Populate DataSet with SqlDataAdapter In the previous section we used SqlDataReader for forward‑only, read‑only streaming access. This section covers SqlDataAdapter, which loads stored procedure …
SqlDataReader
C# ADO.NET Call Stored Procedures with SqlDataReader Call SQL Server stored procedures and stream‑query results using SqlDataReader, key takeaways: Stored Procedure Definition You need to create the stored procedure in …
SqlTransaction database transactions
Transaction: A set of SQL operations that execute atomically. Either all operations get committed (Commit), or everything rolls back on failure (Rollback), complying with the ACID properties.Within .NET Framework/.NET, use …
ExecuteNonQuery
1. Method Overview SqlCommand.ExecuteNonQuery() Applicable Scenarios: INSERT (Create), UPDATE (Modify), DELETE (Remove). Do NOT use it for SELECT queriesReturn Value: int type, representing the number of rows affected after SQL …
Execution optimization and parameter passing
1. Check SqlConnection Connection State Property: conn.State Enum type ConnectionState Note: When used with using, the state automatically changes to Closed after the connection gets disposed.Common states: Open / Closed …
CommandTimeout
What It Means CommandTimeout: command‑execution timeout, measured in seconds Full Working Example Important Notes Concise Object‑Initializer Style Connection Timeout Configuration Defined in connection string, completely independent from CommandTimeout: Connect Timeout=15 …
SqlCommand
Introduction to SqlCommand SqlCommand encapsulates the SQL statements you want to execute. Using an established database connection, it sends instructions to the database and retrieves execution results.The constructor accepts two …
Introduction and Connections
Introduction ADO.NET is the collective term for database‑related modules under the .NET platform.It lets us work with databases to perform basic CRUD operations. We can also run SQL statements, invoke …