public DatabaseHelper(string connectionstring, DBEnum.ProviderType provider)
{
this.strConnectionString = connectionstring;
objFactory = DBFactory.GetProvider(provider);
objConnection = objFactory.CreateConnection();
objCommand = objFactory.CreateCommand();
objConnection.ConnectionString = this.strConnectionString;
objCommand.Connection = objConnection;
}
public static DbDataAdapter GetDataAdapter(DBEnum.ProviderType providerType)
{
switch (providerType)
{
case DBEnum.ProviderType.SqlServer:
return(new SqlDataAdapter());
case DBEnum.ProviderType.MySql:
return(new MySqlDataAdapter());
default:
return(null);
}
}
public static DbProviderFactory GetProvider(DBEnum.ProviderType provider)
{
switch (provider)
{
case DBEnum.ProviderType.SqlServer:
objFactory = SqlClientFactory.Instance;
break;
case DBEnum.ProviderType.MySql:
objFactory = MySqlClientFactory.Instance;
break;
}
return(objFactory);
}
public DBManager(DBEnum.ProviderType provider)
{
DBProvider = provider;
}