|
|
|
|
|
Total Hits: 221 | Today: 0
|
Author: Bipin Joshi
|
Rating:
|
|
When you use SqlDataAdapter for performing updates, the SqlDataAdapter propagates the updates one by one. That means if there are 100 rows to be updated the SqlDataAdapter will execute 100 separate operations against the database. As you might have guessed this is not efficient while dealing with large number of rows. Fortunately SqlDataAdapter allows you to execute updates in batches. You can specify the batch size i.e. number of rows to be treated as a single batch via UpdateBatchSize property...
|
|
|
|
Total Hits: 72 | Today: 0
|
Author: Jay Tallamraju
|
Rating:
|
|
Microsoft released many different tools and technologies recently and still more to come. For some people all this is happening at a time, where they are just becoming comfortable with .NET 1.1 and Visual Studio .NET 2003. Also there are few developers who are just getting a hold on application blocks or Enterprise Library vs. custom coding. Unfortunately not everyone get the time to update their skills, using new technology, mostly due to current workload and projects that are already developed...
|
|
|
|
Total Hits: 159 | Today: 0
|
Author: Raghu Vangala
|
Rating:
|
|
. Net has many cool features for SQL server 2000 to improve the over all scalability of the applications. We will see one of the cool futures today; retrieve multiple result sets in a single SqlDataReader....
|
|
|
|
Total Hits: 122 | Today: 0
|
Author: Code Architects
|
Rating:
|
|
A very important issue you must tackle when designing a business layer is how you plan to manage transactions. Many business methods call multiple DAL methods internally to update, insert, or delete multiple records, potentially in multiple tables. You must ensure that multiple calls run within a transaction, so that if one fails, all actions performed by previous methods are rolled back. If you don’t do this, you’ll end up having inconsistent, and wrong, data. Managing transactions would be com...
|
|
|
|
|
|
