ADO.NET Applications from SQL Server to MySQL

What is ADO.NET?

ADO.NET is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. Microsoft provides ADO.NET Data Provider for SQL Server (System.Data.SqlClient namespace) to access SQL Server. To access MySQL, you can use MySQL Connector/NET, a native ADO.NET Data Provider for MySQL (MySql.Data.MySqlClient namespace).

Why Ispirer Toolkit?

The tool helps you to automatically perform comprehensive assessment and migration of embedded SQL statements (dynamic SQL) as well as ADO.NET provider classes & methods in .NET applications. With Toolkit there is no need extracting SQL statements from application code and convert them separately. The tool completes the whole migration process internally.

Conversion features

Ispirer Toolkit automates the following migration activities:

• Changing Connection String
• Changing ADO.NET namespaces:

MSSQLServer	MySQL
System.Data.SqlClient	MySql.Data.MySqlClient



• Mapping Basic ADO.NET Classes:

.NET Framework	MSSQLServer	MySQL
Connection	SqlConnection	MySqlConnection
Command	SqlCommand	MySqlCommand
DataReader	SqlDataReader	MySqlDataReader
DataAdapter	SqlDataAdapter	MySqlDataAdapter
Parameter	SqlParameter	MySqlParameter
Etc.



• Converting Dynamic SQL language elements and built-in functions with different syntax in SQL Server and MySQL

	SqlDataAdapter da = new SqlDataAdapter();
	da.SelectCommand = new SqlCommand("SELECT ISNULL(Itemtypeid,'N/A') FROM ItemTypeMaster", _conn);

	MySqlDataAdapter da = new MySqlDataAdapter();
	da.SelectCommand = new MySqlCommand("SELECT IFNULL(Itemtypeid,'N/A') FROM ItemTypeMaster", _conn);

How to convert?

A detailed description of such migration process can be found at: Embedded SQL and Database Access API Migration

Assessment

The product can be an effective assessment tool for your project. The assessment process is a turn-key solution for estimating efforts and costs of migration. For ADO.NET and Dynamic SQL in .NET applications conversion the assessment can involve the following:

• Identify source files containing database access code statements
• Identify lines of code with database related statements
• Identify SQL statements

Ispirer Toolkit automates the entire migration of ADO.NET and Dynamic SQL in .NET applications. This allows you to dramatically decrease conversion risks and significantly reduce in-house efforts. Reasonable pricing strategy makes Ispirer software even more powerful instrument for such migration type.