Top "Ado.net" questions

ADO.

ADO.NET - The Size property has an invalid size of 0

I'm trying to get output value from DB via ADO.NET. There's a client code: using (var connection = new SqlConnection(…

c# sql-server ado.net
What is the difference between dataview and datatable?

What is the difference between DataView and DataTable in .Net? As far as I understand DataView is just a false …

c# .net ado.net
ADO.NET Entity Framework: Update Wizard will not add tables

I added a new ADO.Net Entity Data Model into my project and used the Update Wizard to add tables …

.net visual-studio-2008 entity-framework ado.net primary-key
SqlDataReader to read into List<string>

I am writing a method in C# to query a SQL Server Express database from a WCF service. I have …

c# sql wcf ado.net sql-server-express
How do I connect to a SQL database from C#?

I am trying to write a local program management and install system for my home network, and I think I've …

c# .net sql-server ado.net sql-server-express
Cannot access SqlTransaction object to rollback in catch block

I've got a problem, and all articles or examples I found seem to not care about it. I want to …

c# sql transactions ado.net rollback
What is the recommended batch size for SqlBulkCopy?

What is the recommended batch size for SqlBulkCopy? I'm looking for a general formula I can use as a starting …

.net sql-server performance ado.net
copy a single row from one datatable to other

I have two datatables one has few rows other is empty. I am running a loop over first one to …

c# asp.net ado.net datatable datarow
What is the default transaction isolation level for SQL Server with ADO.NET?

What is the default transaction isolation level for SQL Server with ADO.NET? I am using a default installation of …

sql-server-2008 transactions ado.net
TransactionScope Prematurely Completed

I have a block of code that runs within a TransactionScope and within this block of code I make several …

c# sql-server ado.net deadlock transactionscope