C#, accessing different database types (Oracle, SQL Server, MySQL, ...) How do I use SqlConnection class?
Posted on 2010-08-21
In my C# application users can setup various datasources and connect to them to retrieve data. I have so far used OdbcConnection class but I am switching to SqlConnection class (and relevant family classes)
Now, do I need to load different libraries depending on whether it is a SQL Server or a Oracle DB before instantiating the SqlConnection object? Or is it transparent, .NET will use correct underlying libs based on the ADO connection string?
C# VS2010 Professional