OleDBConnection or SQLConnection
-
Hi, I would like to know that which type of object would give better performance in case I want to work with sql server. Should it be OleDBConnection or SQLConnection? Somewhere I read that SQLCOnnection can give better performance but I think at the sql server there is a SNAC (sql server native access client service) or a Net library which anyway consists of OLEDB and ODBC component. So instead if we use OLEDBConnection, wouldn't it be faster? The next query I have is not related to original question but I request to clear my confusion by letting me know which one is better option to free these objects? Should these be freed by Marshal.ReleaseComObject or just closing the connection and then making them NULL? thanks, kMeena
-
Hi, I would like to know that which type of object would give better performance in case I want to work with sql server. Should it be OleDBConnection or SQLConnection? Somewhere I read that SQLCOnnection can give better performance but I think at the sql server there is a SNAC (sql server native access client service) or a Net library which anyway consists of OLEDB and ODBC component. So instead if we use OLEDBConnection, wouldn't it be faster? The next query I have is not related to original question but I request to clear my confusion by letting me know which one is better option to free these objects? Should these be freed by Marshal.ReleaseComObject or just closing the connection and then making them NULL? thanks, kMeena
-
Hi, I would like to know that which type of object would give better performance in case I want to work with sql server. Should it be OleDBConnection or SQLConnection? Somewhere I read that SQLCOnnection can give better performance but I think at the sql server there is a SNAC (sql server native access client service) or a Net library which anyway consists of OLEDB and ODBC component. So instead if we use OLEDBConnection, wouldn't it be faster? The next query I have is not related to original question but I request to clear my confusion by letting me know which one is better option to free these objects? Should these be freed by Marshal.ReleaseComObject or just closing the connection and then making them NULL? thanks, kMeena
-
Hi, If u use sqlclient in that case it use oledb partially (some code of oledb) and rest it will communcate directly with native code , where as if u use oldedb in that case it use fully(complete code of oledb).
Regards Anil Pal
-
Hi, No its mean sqlclient is better bcz it use min code to communicate with DB where as oledb reuquired more
Regards Anil Pal
-
but what if I want to make my application generic. In that case there is no alternative to OLEDB. SqlConnection can not work with oracle database.