Differences between DataAccess.dll and ManagedDataAccess.dll
So far I found two differences between the fully managed version and the "old" version.
If somebody finds other differences it would be nice to add them here.
1. The connection string has "problems" with whitespaces and "CR/LF".
When I start a connection using nhibernate the old version workes with a configuration like this:
Data Source =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxx)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = xxxxxxxxx)
(SERVER = DEDICATED)));
User Id=test;
Password=test;
while the new managed version needs this:
Data Source =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxx)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = xxxxxxxxx)
(SERVER = DEDICATED)));User Id=test;Password=test;
Else you get an error about " User Id:"
2. Due to an error in our code there was a possibility to call "Dispose" on an OracleCommand twice.
The new version throws an exception now. (which is good as it shows the error)
The old version runs without any error being thrown.