Aminoochek
New Member
I am using asp.net and currently working with SQL SERVER 2008.In my code all the DML operation is happening with the help of SqlConnection, SqlCommand, SqlDataAdapter.But when If my database move to ORACLE or MySQL then I would need to write the code for ORACLE -- OLEDBConnection, OLEDBCommand, OLEDBDataAdapterMySQL -- Would need to include a MySQL dll.Now due to this huge change I would need to write the entire code again. [*]Is there any way to overcome this problem that we write the code at once and that would not depend on the database provider? [*]Does the Entity Framework come in this picture anywhere?Please guide me.