Recently our project is migrating from legacy DB to SQl Server and we need to move our database layer. Currently we are using OledbConnection for Database. Now since we are migrating to SQL Server, is it good to migrate whole Database to use SqlConnection
or keeping OledbConnection is a better option? Is there any performance advantage with SqlConnection?
techknackblo...
Member
5 Points
5 Posts
OledbConnection vs SqlConnection
Mar 06, 2012 02:03 PM|LINK
Recently our project is migrating from legacy DB to SQl Server and we need to move our database layer. Currently we are using OledbConnection for Database. Now since we are migrating to SQL Server, is it good to migrate whole Database to use SqlConnection or keeping OledbConnection is a better option? Is there any performance advantage with SqlConnection?
Rishi
www.techknackblogs.com
www.techknackblogs.com