Tagged pages

Found 5 articles tagged with ADO

Serialize DataTable to JSON with just few lines of code
Generate JSON string from DataTable in C#
Although JSON is widely used as a format for sharing the data, there are still existing solutions or modules that still rely on ADO and DataTables. Even today it very common to see some piece of code which deals with DataTable or DataReader for the performance reasons. In the end if any of the ADO objects needs to be exposed as a JSON string you have to write your own serialization code. ... read more
SqlBulkCopy with model classes in C#
Use SqlBulkCopy with model (POCO) classes in C#
So far (based on my experience) the fastest way to insert big number of records from application to database is to use SqlBulkCopy. The downsize of this is that SqlBulkCopy uses DataTable instace as an input parameter which is not so convenient when dealing with models which are strongly typed and a lot more easy to use than iterating through the DataTable... read more
Easy and simple way to bind ADO object to POCO object
Simple one way binding of ADO database objects to POCO
This article is base don the article I wrote in September last year. Basically I wrote this piece of code because I needed something really lite for one way binding... read more
Super lightweight Data Access Layer returning models from ADO
Return strongly typed objects directly from stored procedure calls
Entity framework is an awesome tool for working with database in .net, but sometime you have to get back to old fashion ADO for the performances. The bad thing is that as soon as you get back to ADO, you have to deal with SqlDataReader, DataTable and DataSet classes... read more
Transform comma seperated string to rows in SQL Server
Use comma separated string in TSQL
Passing complex data to and from stored procedures has always been a tricky one. The most elegant way to pass values to a stored procedure is to use predefined data types in SQL Server... read more