There is no DataReader class in ADO.NET , but there are a number of classes that implement the IDataReader interface: System.Data.SqlClient.SqlDataReader; System.Data.OleDb ...

18 cool Extension Methods for cleaner data access using the DataReader class. Cut down your data access code by using these 18 Extension Methods. Full source code available for ...

... Cool Extension Methods for IDataReader Interface ... Site Links Home Search Digg RSS Feeds Popular Archive Terms of Use , Privacy Report a ...

18 cool Extension Methods for cleaner data access using the DataReader class. Cut down your data access code by using these 18 Extension Methods. Full source code available for ...

... Cool Extension Methods for IDataReader Interface ... Site Links Home Search Digg RSS Feeds Popular Archive Terms of Use , Privacy Report a ...

Provides a means of reading one or more forward-only streams of result sets obtained by executing a command at a data source, and is implemented by .NET Framework data providers ...

... means removing any dependencies with other components; for example I needed to test in isolation a class that is instanciated by passing to it an object that implements IDataReader

... means removing any dependencies with other components; for example I needed to test in isolation a class that is instanciated by passing to it an object that implements IDataReader

public interface IDataReader : , IDataRecord , IDisposable. Remarks This class provides a forward-only way to go through the results of a query.

One of the things easily forgotten and under used is the "Using" statement. This is especially important when you have IDataReader implemented in your application as it doesn't ...

at System.Data.Common.DbDataAdapter.FillNextResult(IDataReader dataReader) at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader ...

Hi, try this OracleCommand cmd = (OracleCommand)conn.CreateCommand(); cmd.CommandText = "SELECT company_name FROM customers WHERE company_name = ? " ocmd.Parameters.Add( "COMPANY ...

Converts a native document to XML. For a list of all members of this type, see IDataReader Members . ...

Provides advanced instructor-led training for software developers in Microsoft .NET, WPF, WCF, WF, ASP.NET, SharePoint, AJAX, SQL, Biztalk, java and C++ in both public and onsite ...

DataTable - Load from IDataReader - CreateDataReader - ReadXml WriteXml - Free ADO.NET Tutorials. The DataTable in ADO.NET 2.0 has been seriously beefed up and I absolutely love it ...

Provides a means of reading one or more forward-only streams of result sets obtained by executing a command at a data source, and is implemented by .NET Framework ...

Fills a DataTable with values from a data source using the supplied IDataReader. ... infers the schema based on the result set from the imported IDataReader. ...

ASP.NET Forums General ASP.NET Getting Started when to use IDataReader ? ... IDataReader is referring to an interface. Basically If your method accepts ...

IDataReader. Get answers to your questions in our .NET C# forum. ... Using IDataReader (which is hte interface) ... or anything else that implements IDataReader ...

I believe I read somewhere that when the IDataReader is closed, the connection is closed. ... return iDataReader ; #endregion SelectVehicleSoldByDealership. EXAMPLE 2 ...

If you've done much heavy lifting (or any lifting at all) in ADO.NET, you've no doubt used a ... The key to this is that IDataReader also implements IDataRecord, so we can just ...

DataTable - Load from IDataReader - CreateDataReader - ReadXml WriteXml ... The DataTable now has a Load method that accepts an IDataReader as an argument: ...

In this article, Joydip demosntrates the working of a provider independent DAL layer in C# with relevant source code. ... · IDataReader · IDbCommand · IDbDataAdapter ...

Get an IDataReader from the WineDataProvider for all the Wine produced by the ... For each record in the IDataReader ... the IDataReader.NextResult() method ...

Hi Recently I discovered the SqlDependency object which is part of the ADO.NET 2.0. This class is not new (actually it's pretty old - since 2005) but somehow I wasn't aware of it. Introduction MSSQL 2005 contains several new features. One of them is called Service Broker which is in general messaging technology between external and internal processes. I won't go into details but this feature has many uses. The SqlClient namespace in ADO.NET 2.0 contains some new objects that use the Servic

Since this is probably the most-often reused piece of code I’ve written recently, I thought it may be worth sharing. It is pretty raw still, so I will post it to the wiki as well, and hopefully people will see ways to improve it (and show us!). Here is the link to the wiki page: Generic List Provider in C#. I wrote this because I found myself constantly writing code to fill lists of objects from database commands. I was too far into the project and the project was a little to small to justify

I tend to agree with those who believe that a good ORM will give you 90% of what you need. For me, with NHibernate and ActiveRecord it’s been closer to 95%. The remaining 5% tends to involve getting a DbConnection instance and executing some legacy stored procedure or something of that nature. For this post, I’ll describe a recent scenario that fell into that lesser bucket… I recently decided to add full-text search to Jeopardy Story. I’d previously used full-text search for my articles on Cod

ActiveRecord, NHibernate and SQL Stored Procedures I love ActiveRecord and NHibernate as ORMs. They do exactly as it says on the tin. I love the fact that I can develop an application in a DDD (Domain Driven Development) fashion and almost forget about the fact that I need a relational database. I also love the fact that I don't have to write lengthy Stored Procedures to get data back....but there is always an application out there where this has to change. I currently working on a new proj

using System.Data.Odbc; using System.Data; private DataSet DataReaderToDataSet(IDataReader reader) { DataTable table = new DataTable(); int fieldCount = reader.FieldCount; for (int i = 0; i < fieldCount; i++) { table.Columns.Add(reader.GetName(i), reader.GetFieldType(i)); } table.BeginLoadData(); object[] values = new object[fieldCount]; while (reader.Read()) { reader.GetValues(values); table.LoadDataRow(values, true); } table.EndLoadData(); DataSet ds = new DataSet(); ds.Tables.Add(t

public DataSet DataReaderToDataSet(IDataReader reader) { DataTable table = new DataTable(); int fieldCount = reader.FieldCount; for (int i = 0; i

In my post How to extend classes using extension methods, I write about how to extend classes with your own methods. This time we will extend the IDataReader interface with some new methods to save some typing. Since we extend the interface, our methods will be available in all the classes implementing the IDataReader interface, such as the SqlDataReader. The IDataReader interface provides methods for getting field values for a given type: string email = reader.GetString(0); The problem with

In my post How to extend classes using extension methods, I write about how to extend classes with your own methods. This time we will extend the IDataReader interface with some new methods to save some typing. Since we extend the interface, our methods will be available in all the classes implementing the IDataReader interface, such as the SqlDataReader. The IDataReader interface provides methods for getting field values for a given type: string email = reader.GetString(0); The problem with

In most applications database access is restricted to a single database type. if you need to connect to multiple types of databases? Do you write a data access class for each database? When faced with this dilemma working on a project I decided to use a single class and create the data access objects through reflection. ############################################ DataProviderFactory.cs Class ############################################ using System.Data; using System.Collections; using

using System; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace RUBRUDATAACCESS.SQL { public class DATALAYER:IDisposable { private IDbCommand cmd=new SqlCommand(); private string strConnectionString=”"; private bool handleErrors=false; private string strLastError=”"; public DATALAYER() { ConnectionStringSettings objConnectionStringSettings = ConfigurationManager.ConnectionStrings["connect"]; strConnectionString = objConnectionStringSettings.Co