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); }