OleDBDataAdapter & SqlDataAdapter

[EricDotNet]

Would u tell me the different between them?

 

I need to start a project which is involve huge size of data (above millions rows in one table)

 

So, I want to know which one is better for my project.

Thx.

[Robby]

SqlDataAdapter and SqlDataClient are only for SQL Server 7 and 2000,

OraDataClient is for Oracle,

OleDBDataAdapter and all OleDbData onjects are for the rest of the data providers such as MS Access.

 

 

However there are more data clients in development for other providers

[foz]

choose which one is appropriate for your information, sql for sql server oledb for access etc...

 

with that much info i'd recommend a sql server db, with sqldataadapters

[Joe Mamma]

choose which one is appropriate for your information, sql for sql server oledb for access etc...

 

with that much info i'd recommend a sql server db, with sqldataadapters

Keep in mind, using SQLDbClient locks you into SQL Server.

 

It may be preferable to program to an IDB* Interfaces:

 

[color=black][size=2]public [/size][size=2]enum [/size][/color][size=2]DBServiceEnum[/size]


[size=2]{[/size]
[indent][size=2]SQL, [/size]

[size=2]Oracle,[/size]
[size=2]OleDb,[/size]
[size=2]ODBC[/size]

[/indent]
[size=2]}

[/size]

public class MyClass 


{
[indent]IDbConnection myConn = null;


public void InitDBComponents(DBServiceEnum appDbType) 


{[indent]switch (appDbType)



{[indent]case DBServiceEnum.SQL: [indent]myConn = new SqlConnection();

break;

[/indent]
case DBServiceEnum.Oracle: 
[indent]myConn = new OracleConnection();

break;

[/indent]
case DBServiceEnum.OleDb: 
[indent]myConn = new OleDbConnection();

break;

[/indent]
case DBServiceEnum.ODBC: 
[indent]myConn = new OdbcConnection();

break;

[/indent]
[/indent]}


[/indent]}


[/indent]}

 

Programming to interfaces makes your client applications immune to service definitions.

 

Joe Mamma

[Robby]

Here's an easy to follow sample using a Factory Pattern. http://www.c-sharpcorner.com/Code/2002/July/GenericDataAccessCompActivator.asp

[Joe Mamma]

Here's an easy to follow sample using a Factory Pattern. http://www.c-sharpcorner.com/Code/2002/July/GenericDataAccessCompActivator.asp

Thanks for the post Robby!

 

and a great example of alot of key concepts.

 

joe