I'm new to .NET. I have used OLEDB for SQL server 7 and 2000. But In the .NET documentation Microsoft is recommending usage of SQL server .NET data provider for accessing MSSQL 7 and above and MSDE.

Will you please tell me what are the advantages of using .NET library over OLEDB ?

Is the use of OLEDB for accessing SQL 7 and 2K affecting performance of my application ?


Thanks and regards,
Udayt