public FileDbConnectionProvider(string name, string connectionString, DbFileType fileType)
: base(name, ConnectionProviderType.DbFile, new SimpleDbConnectionStringBuilder(connectionString))
{
this.DbFileType = fileType;
this.FileLink = FileLink.CreateLink(DataSource, this.UserId, this.Password);
this.FileLink.Options = ConnectionBuilder;
this.DataFile = DbFile.Create(DbFileType, FileLink);
}
public void ExecuteDataToDBFile(DbFileType dbFileType, string dbFileFullpath, string querySql, DateTime startTime, DateTime endTime)
{
switch (dbFileType)
{
case DbFileType.SQLite:
this.ExecuteDataToSQLite(dbFileFullpath, querySql, startTime, endTime);
break;
case DbFileType.Access:
this.ExecuteDataToAccess(dbFileFullpath, querySql, startTime, endTime);
break;
default:
throw new ArgumentNullException("DbFileType未赋值");
}
}
/// <summary>
/// 得到数据文件扩展名
/// </summary>
/// <param name="dbFileType"></param>
/// <returns></returns>
public static string GetDBFileExtName(DbFileType dbFileType)
{
string dbExtName = "";
switch (dbFileType)
{
case DbFileType.Access:
dbExtName = ".mdb";
break;
case DbFileType.SQLite:
dbExtName = ".db";
break;
default:
dbExtName = ".db";
break;
}
return(dbExtName);
}
public static IDbFile Create(DbFileType type, FileLink link)
{
switch (type)
{
case DbFileType.XmlDb:
return(new XmlDbFile(link));
case DbFileType.XmlDataSet:
return(new DataSetFile(link));
case DbFileType.XmlDataLake:
return(new DataLakeFile(link));
case DbFileType.CSharp:
return(new CSharpFile(link));
case DbFileType.Assembly:
return(new AssemblyFile(link));
}
return(null);
}
