mysql对应net_.NET平台下使用C#连接各种数据库

public class SqlDataSourceProvider : DbDataSourceProvider

{

///

/// the connections string is just like @"Data Source=WSWINCNHZ0823;Initial Catalog=D:\SITES\TMS\SERVICES\DataService\APP_DATA\TMS.MDF;Integrated Security=True";

///

///

public SqlDataSourceProvider(string connectionString)

: base(connectionString)

{

}

public override DbConnection GetDbConnection()

{

var connection = new SqlConnection(this.ConnectionString);

return connection;

}

public override DataAdapter CreateAdapter(string query, DbConnection connection)

{

return new SqlDataAdapter(query, connection as SqlConnection);

}

}