.NET Tutorials, Patterns, and Practices
Browse by Tags
All Tags »
ADO.NET (
RSS)
-
|
After several discussions recently, I am suspecting a number of people are using the old SqlHelper and the new Enterprise Library Data Access Application Block as their data access layer, but I don't believe this is the original intent of the Patterns...
|
-
|
Kudos to Pablo Castro, the Program Manager for the ADO.NET Team at Microsoft, for explaining why SqlBulkCopy in ADO.NET 2.0 is faster than inserting records into a table. "There are a number of reasons why bulk-copy is faster. Here is a summary: No per...
|
-
|
Parameterized queries can help you with injection attacks, but they can also help with performance as most databases will attempt to improve their performance by caching query plans. If you use string concatentation when forming queries as shown below...
|
-
|
We've all been drilled on the cardinal rule of connection pooling: "open connections as late as possible, and close connections as early as possible." Normally when you see code using a DataAdapter like below: using (SqlConnection connection = new SqlConnection...
|
-
|
The SqlConnection object has a new RetrieveStatistics method in .NET 2.0, which provides some interesting statistics that could come in handy while debugging and performance tuning your .NET applications. Normally statistics are turned off by default...
|
More Posts