I was using the below code to connect to SQL Azure DB that was using Active Directory Integrated Authentication. private string GenerateConnectionString(string databaseName, string serverName) { ...

I want to use DataTable class on iOS. I am implementing DataTable class as you see in the code. It works fine on Android and Standalone builds with Unity. I cannot figure it out why iOS is not woki...

I was looking for a smart conversion between .Net System.Type and SqlDbType. What I found it was the following idea: private static SqlDbType TypeToSqlDbType(Type t) { String name = t.Name; SqlD...

There is DataTable with primary key to store information about files. There happen to be 2 files which differ in names with symbols '4' and '４' (0xff14, a "Fullwidth Digit Four" symbol). The DataTa...

I'm rewriting/converting some VB-Code: Dim dt As New System.Data.DataTable() Dim dr As System.Data.DataRow = dt.NewRow() Dim item = dr.Item("myItem") C#: System.Data.DataTable dt = new System.D...

My project's codebase has a legacy method that takes a DataRow as a parameter for which I would like to create a unit test method. How can I manually create a DataRow object to pass to the method?...

In the past when I have been implementing unit test I have struggled to set up 'decent' unit tests for data access layers because they often have a database as an external dependency. In an ideal w...

I am trying to write a couple of extensions to convert UniDataSets and UniRecords to DataSet and DataRow but I get the following error when I try to compile. 'System.Data.DataRow.DataRow(System....

I understood the implicit rollback (that usually happens when exception happens and Dispose is called) is not guaranteed for all providers. However many examples uses: using (DbTransactio txn = cn...

How is the option CommandType.Tabledirect used unlike CommandType.StoredProcedure or CommandType.Text?

I have a reference to System.Data in my windows service project. I keep getting the Exception : Could not load file or assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77...

I've been running into some problems concerning a SqlTransaction I'm using in my code. During my Googling I see many people using a using statement with a SqlTransaction. What is the benefit and/o...

Is is possible to use a custom .NET data provider without installing it in the GAC? Can I reference a custom DLL and register it inside my configuration file?

Under the namespace System.Data.SqlClient, we have both SqlDataReader.GetSqlBinary and SqlDataReader.GetSqlBytes. Both seems to give "raw data". If so, what's the difference between them?

I'm a low-level algorithm programmer, and databases are not really my thing - so this'll be a n00b question if ever there was one. I'm running a simple SELECT query through our development team's...