ado.net Examples and Free Source Code

ADO.net SqlParameter using a + sign between words...

c#sql-server ado.net

ADO NET Source/Destination components missing from SSIS Toolbox...

sql-server visual-studio ssis ado.net visual-studio-2022

SSIS Package Fails due to ADO NET source could not create connection manager with Netsuite...

sql-server ssis ado.net etl netsuite

Parent-Child Insertion inside TransactionScope cause foreign key constraint error...

c#sql-server ado.net transactionscope

Move On To Next Record If Condition Not Met...

c#ado.net datareader

"Invalid data for UTF8-encoded characters" exception in SQL Server 2019...

vb.net utf-8 ado.net sql-server-2019 sqlclient

Best method for transferring data between Access database to SQL database...

c#sql-server ms-access ado.net odbc

Connect to SAP through C# application...

c#asp.net oracle ado.net sap-erp

LINQ Dynamic QUERY to produce 'where AssignedUser is null'...

c#sql linq ado.net expression

C# Login form with User Authentication with SQL Server database...

c#sql-server winforms ado.net

How to insert data into DB from textbox...

c#asp.net ado.net

Handling 'Sequence has no elements' Exception...

c#.net linq entity-framework ado.net

Can I save an 'Object' in a SQL Server database?...

c#sql-server sql-server-2005 ado.net

Crystal reports showing numbers as hash #...

vb.net crystal-reports ado.net

Why there's no `DBconnection.CloseAsync()` while there is `DBconnection.OpenAsync()`?...

c#asynchronous ado.net async-await dbconnection

How do I return multiple result sets with SqlCommand?...

c#sql-server ado.net

SQL Anywhere Error -157: Cannot convert '08/10/09' to a timestamp...

c#database ado.net sybase sqlanywhere

MetadataException: Unable to load the specified metadata resource...

c#.net entity-framework ado.net

How can I use SQLite ADO.net data provider?...

c#.net sqlite ado.net

SQL: Update a row and returning a column value with 1 query...

c#sql-server t-sql ado.net

DbProviderFactories.RegisterFactory parameters for Net.IBM.Data.Db2 for .NET 7.0...

c#.net db2 ado.net .net-7.0

Can ADO.NET DataTables hold data of types other than Object when grabbing data from a SQL Server?...

c#.net types datatable ado.net

Using ThreadPool threads with long running ADO.NET queries. Is this scalable?...

asp.net multithreading ado.net threadpool

Serializing SQL Json response...

c#sql .net model-view-controller ado.net

What scope does a using statement have without curly braces...

c#ado.net using-statement

multithreaded transaction causes -271 informix error code on table insertion...

ado.net odbc informix parallel.foreach locks

I've written identical code for DataSet and DataTable. Can this be DRY'd?...

c#generics datatable dataset ado.net

From a parameter-usage viewpoint, is calling a table-valued functions from ADO.NET the same as a sto...

c#.net ado.net user-defined-functions sqlparameter

When calling a stored procedure with ADO.NET, how do I tell what parameter types the database actual...

c#stored-procedures ado.net nvarchar sqlparameter

Is AddWithValue only dangerous for strings?...

c#.net parameters ado.net sqlparameter