Top "Ado.net" questions

ADO.

MySQL Data Source not appearing in Visual Studio

I just installed the ADO.NET connector from here http://dev.mysql.com/downloads/connector/net/ Yet MySQL doesn't appear …

mysql visual-studio-2012 ado.net
How to get Database Name from Connection String using SqlConnectionStringBuilder

I never want to split connection string using string manipulation and get server,database,uid and password. I read the …

c# asp.net sql ado.net
how to resolve DTS_E_OLEDBERROR. in ssis

In an ssis package consists of data flow task,contains OLEDB source and OLDB Target ..provider is sql native client..…

sql-server ado.net oledb ssis
How do I obtain a list of all schemas in a Sql Server database

I want to retrieve a list of all schemas in a given Sql Server database. Using the ADO.NET schema …

c# .net sql-server ado.net
When using Trusted_Connection=true and SQL Server authentication, will this affect performance?

If a connection string specifies Trusted_Connection=true with SQL Server authentication mode, will performance of my web application be …

c# .net asp.net sql-server-2005 ado.net
Getting datarow values into a string?

I have a dataset called "results" with several rows of data. I'd like to get this data into a string, …

c# ado.net datarow
Error: No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'

I recently upgraded/updated Entity Framework in an old project from version 4 or 5 to version 6. Now I get this exception: …

c# .net entity-framework ado.net entity-framework-6
How can i query for null values in entity framework?

I want to execute a query like this var result = from entry in table where entry.something == null select entry; …

.net entity-framework ado.net
How to select top n rows from a datatable/dataview in ASP.NET

How to the select top n rows from a datatable/dataview in ASP.NET? Currently I am using the following …

c# asp.net ado.net
How to fill Dataset with multiple tables?

I'm trying to fill DataSet which contains 2 tables with one to many relationship. I'm using DataReader to achieve this : public …

c# sql ado.net dataset datareader