hi everyone
i was questiontioned that why there is need for seperate sqlclient provider for ado.net already oledb provider works as generic provider which works for all connections
thanks
waiting for answer

The native SQL .NET client is optimized for SQL Server. Yes, you can connect to a SQL server through ADO, but that adds the layer of ADO to the connection overhead. SqlClient connects directly to SQL and is therefore faster. It is likely there is also better support for more complex task involving transactions and the like that can be accomplished with optimized/direct connection.

-Peter