//This method returns a specific connectionstringbuilder object //based on the value of a DataBaseProvider enum public static DbConnectionStringBuilder GetConnectionStringBuilder(DataBaseProvider dataProvider, string connectionString) { DbConnectionStringBuilder stringBuilder = null; switch (dataProvider) { case DataBaseProvider.SqlServer: stringBuilder = new SqlConnectionStringBuilder(connectionString); break; case DataBaseProvider.OleDb: stringBuilder = new OleDbConnectionStringBuilder(connectionString); break; case DataBaseProvider.Odbc: stringBuilder = new OdbcConnectionStringBuilder(connectionString); break; case DataBaseProvider.None: break; default: break; } return(stringBuilder); }
/// <summary> /// 商品 /// </summary> /// <returns></returns> public ActionResult shangpin() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.InsertEntity(new ShangPin { ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "中长款连帽棉服男装" }.CreateQSmartObject()); db.InsertEntity(new ShangPin { ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "韩版修身男装棉袄" }.CreateQSmartObject()); db.InsertEntity(new ShangPin { ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "时尚羊羔绒棉服外套" }.CreateQSmartObject()); db.InsertEntity(new ShangPin { ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "可脱卸大毛领连帽棉衣" }.CreateQSmartObject()); db.InsertEntity(new ShangPin { ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "时尚连帽棉服" }.CreateQSmartObject()); db.InsertEntity(new ShangPin { ShangPinFenLeiId = 1, ChiMaZuId = 2, YanSeZuId = 2, PinPaiId = 2, Name = "保暖情侣潮上衣" }.CreateQSmartObject()); db.InsertEntity(new ShangPin { ShangPinFenLeiId = 1, ChiMaZuId = 2, YanSeZuId = 2, PinPaiId = 2, Name = "男士长袖POLO衣" }.CreateQSmartObject()); db.SaveChange(); return(Content("ok")); }
/// <summary>Raises the <see cref="E:System.Windows.Application.Startup" /> event.</summary> /// <param name="e">A <see cref="T:System.Windows.StartupEventArgs" /> that contains the event data.</param> protected override void OnStartup(StartupEventArgs e) { var version = typeof(App).Assembly.GetName().Version; Log.Info($"Managing app started. Program version: {version}."); AppDomain.CurrentDomain.UnhandledException += CurrentDomainOnUnhandledException; base.OnStartup(e); var prioritySearcher = new PriorityVectorSearcher(); var context = new DssContext(); var dataProvider = new DataBaseProvider(context); var viewModelList = new List <IPageViewModel> { new TaskManagingViewModel(dataProvider), new InputViewModel(dataProvider), new PairMatrixViewModel(dataProvider), new ResultViewModel(dataProvider, prioritySearcher) }; var mainWindowViewModel = new MainWindowViewModel(viewModelList, dataProvider); var mainWindow = new MainWindow { DataContext = mainWindowViewModel }; Log.Info("Initialize is successful"); mainWindow.Show(); }
public void Process(EntityTypeBuilder <T> builder, DataBaseProvider provider, Func <IConfigurationRuleSet, bool> filter = null) { var mappingRuleSets = filter == null ? _rulesFactory.Value : _rulesFactory.Value.Where(filter); foreach (var mappingRuleSet in mappingRuleSets) { foreach (var rule in mappingRuleSet.GetRules <T>()) { var propertyBuilder = builder.Property(rule.PropertyType, rule.PropertyName); if (rule.IsConcurrencyToken) { propertyBuilder = propertyBuilder.IsConcurrencyToken(); } if (rule.IsRequired) { propertyBuilder = propertyBuilder.IsRequired(); } if (rule.MaxLength.HasValue) { propertyBuilder = propertyBuilder.HasMaxLength(rule.MaxLength.Value); } var columnName = rule.HasColumnName ? DbColumnBuilder.CreateWithPristineValue(rule.ColumnName, provider).Build() : DbColumnBuilder.CreateWithNormalizedValue(rule.PropertyName, provider).Build(); propertyBuilder.HasColumnName(columnName); } } }
/// <summary> /// 处理连接串,参数支持Diction<string,object>,DbParameter[] , new{} /// </summary> /// <param name="param"></param> /// <param name="cmd"></param> internal void SetupDbCommand(object param, ref DbCommand cmd) { if (null == param) { return; } IEnumerable <DbParameter> dbpars = param as IEnumerable <DbParameter>; if (null != dbpars) { foreach (var ele in dbpars) { cmd.Parameters.Add(ele); } } else { IDictionary <string, object> dic = SmartCrud.SmartCrudHelper.AsDictionary(param); if (null != dic) { foreach (var ele in dic) { #if !REF_ALL_DB || NETFRAMEWORK var par = this.dbProvider.CreateParameter(); #else var par = DataBaseProvider.GetParameter(this.DbType); #endif par.ParameterName = ele.Key.TrimParaName(); par.Value = ele.Value; cmd.Parameters.Add(par); } } } }
//This method returns a specific command object //based on the value of a DataBaseProvider enum public static DbCommand GetCommand(DataBaseProvider dataProvider) { DbCommand command = null; switch (dataProvider) { case DataBaseProvider.SqlServer: command = new SqlCommand(); break; case DataBaseProvider.OleDb: command = new OleDbCommand(); break; case DataBaseProvider.Odbc: command = new OdbcCommand(); break; case DataBaseProvider.None: break; default: break; } return(command); }
public ActionResult CreateTable() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); //db.CreateTable<ShangJia_ShangPin_TuCe>(QSmartTableType.InnoDB); //db.CreateTable<ShangJia_Sku_Info>(QSmartTableType.InnoDB); //db.CreateTable<ShangJia_Sku_TuTou>(QSmartTableType.InnoDB); //db.CreateTable<YanSeZu>(QSmartTableType.InnoDB); //db.CreateTable<YanSeZuMingXi>(QSmartTableType.InnoDB); //db.CreateTable<YanSe>(QSmartTableType.InnoDB); //db.CreateTable<ChiMaZu>(QSmartTableType.InnoDB); //db.CreateTable<ChiMaZuMingXi>(QSmartTableType.InnoDB); //db.CreateTable<ChiMa>(QSmartTableType.InnoDB); //db.CreateTable<PinPai>(QSmartTableType.InnoDB); db.CreateTable <ShangPin>(QSmartTableType.InnoDB); //db.CreateTable<ShangPinFenLei>(QSmartTableType.InnoDB); //db.CreateTable<JingXiaoShang>(QSmartTableType.InnoDB); //db.CreateTable<CaoZuoYuan>(QSmartTableType.InnoDB); //db.CreateTable<MenDian>(QSmartTableType.InnoDB); ////db.CreateTable<MenDian_CanZuoYuan_GuanLian>(QSmartTableType.InnoDB); //db.CreateTable<CangKu>(QSmartTableType.InnoDB); //db.CreateTable<HuoWei>(QSmartTableType.InnoDB); //db.CreateTable<RuKu>(QSmartTableType.InnoDB); //db.CreateTable<RuKuMingXi>(QSmartTableType.InnoDB); return(Content("ok")); }
public ActionResult yansechima() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.InsertEntity(new YanSe { Name = "红色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "黑色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "藏蓝色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "白色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "墨绿色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "天青色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "黄色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "绿色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "草绿色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "紫色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "宝石蓝色" }.CreateQSmartObject()); db.InsertEntity(new YanSe { Name = "磨砂岩色" }.CreateQSmartObject()); db.InsertEntity(new ChiMa { Name = "S" }.CreateQSmartObject()); db.InsertEntity(new ChiMa { Name = "M" }.CreateQSmartObject()); db.InsertEntity(new ChiMa { Name = "L" }.CreateQSmartObject()); db.InsertEntity(new ChiMa { Name = "XL" }.CreateQSmartObject()); db.InsertEntity(new ChiMa { Name = "XXL" }.CreateQSmartObject()); db.SaveChange(); return(Content("ok")); }
public ActionResult CreateTable() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.CreateTable <Customer>(QSmartTableType.InnoDB); db.CreateTable <Cart>(QSmartTableType.InnoDB); db.CreateTable <CustomerAddress>(QSmartTableType.InnoDB); db.CreateTable <CustomerOrder>(QSmartTableType.InnoDB); db.CreateTable <Order>(QSmartTableType.InnoDB); db.CreateTable <OrderGoods>(QSmartTableType.InnoDB); Customer ct = new Customer { Id = Guid.NewGuid().ToString().Replace("-", ""), LoginName = "admin", NikeName = "管理员", Password = "******", Phone = "123456789" }; db.InsertEntity(ct.CreateQSmartObject()); db.SaveChange(); db.CreateTable <YanSeZu>(QSmartTableType.InnoDB); db.CreateTable <YanSeZuMingXi>(QSmartTableType.InnoDB); db.CreateTable <YanSe>(QSmartTableType.InnoDB); db.CreateTable <ChiMaZu>(QSmartTableType.InnoDB); db.CreateTable <ChiMaZuMingXi>(QSmartTableType.InnoDB); db.CreateTable <ChiMa>(QSmartTableType.InnoDB); db.CreateTable <PinPai>(QSmartTableType.InnoDB); db.CreateTable <ShangPin>(QSmartTableType.InnoDB); db.CreateTable <ShangPinFenLei>(QSmartTableType.InnoDB); db.CreateTable <JingXiaoShang>(QSmartTableType.InnoDB); db.CreateTable <CaoZuoYuan>(QSmartTableType.InnoDB); db.CreateTable <MenDian>(QSmartTableType.InnoDB); //db.CreateTable<MenDian_CanZuoYuan_GuanLian>(QSmartTableType.InnoDB); db.CreateTable <CangKu>(QSmartTableType.InnoDB); db.CreateTable <HuoWei>(QSmartTableType.InnoDB); db.CreateTable <RuKu>(QSmartTableType.InnoDB); db.CreateTable <RuKuMingXi>(QSmartTableType.InnoDB); return(Content("ok")); /* * CREATE OR REPLACE VIEW `cartview` AS * select `cart`.`Id` AS `Id`,`cart`.`Sku` AS `Sku`,`cart`.`CustomerId` AS `CustomerId`,`cart`.`Actived` AS `Actived`,`cart`.`Quantity` AS `Quantity`,`goodsshelves`.`Description` AS `Description`,`goodsshelves`.`Price` AS `Price` from (`cart` left join `goodsshelves` on((`cart`.`Sku` = `goodsshelves`.`Sku`))); * ; * */ }
public ChatDataSet(string connectionString, DataBaseProvider provider) { _provider = provider; ConfigurateUsersAdapter(connectionString, out _usersDataAdapter); ConfigurateMessagesAdapter(connectionString, out _messagesDataAdapter); CreateDataSet(); FillDataSet(); _usersDV = new DataView(_usersTable); _messagesDV = new DataView(_messagesTable); }//c-tor
public Startup(IConfiguration configuration) { Configuration = configuration; _DataBaseProvider = new DataBaseProvider(); // var logRepository = LogManager.GetRepository(Assembly.GetEntryAssembly()); repository = LogManager.CreateRepository("NETCoreRepository"); XmlConfigurator.Configure(repository, new FileInfo("Config/log4net.config")); }
/// <summary> /// 经销商 /// </summary> /// <returns></returns> public ActionResult jingxiaoshang() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.InsertEntity(new JingXiaoShang { Name = "北京服装经销商", Address = "北京 海淀", Phone = "010-666666" }.CreateQSmartObject()); db.SaveChange(); return(Content("ok")); }
/// <summary> /// 门店 /// </summary> /// <returns></returns> public ActionResult mendian() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.InsertEntity(new MenDian { Name = "北京大红门服装店", JingXiaoShangId = 1, Address = "北京", Phone = "010-666666" }.CreateQSmartObject()); db.InsertEntity(new MenDian { Name = "北京西单服装店", JingXiaoShangId = 1, Address = "北京", Phone = "010-666666" }.CreateQSmartObject()); db.SaveChange(); return(Content("ok")); }
/// <summary> /// 品牌 /// </summary> /// <returns></returns> public ActionResult pinpai() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.InsertEntity(new PinPai { Name = "丹杰仕", Logo = "DANJIESHI" }.CreateQSmartObject()); db.InsertEntity(new PinPai { Name = "佐丹奴", Logo = "Giordano" }.CreateQSmartObject()); db.SaveChange(); return(Content("ok")); }
/// <summary> /// 尺码组 /// </summary> /// <returns></returns> public ActionResult zhimazu() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.InsertEntity(new ChiMaZu { Name = "丹杰仕尺码组", PinPaiId = 1 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZu { Name = "佐丹奴尺码组", PinPaiId = 2 }.CreateQSmartObject()); db.SaveChange(); return(Content("ok")); }
public static ArrayList getRecommend() { MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select * from recommender"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Connection.OpenAsync(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); ArrayList recommendList = new ArrayList(); try { while (reader.Read()) { if (reader.HasRows) { int userId = reader.GetInt32(0); string userCF = reader.GetString(1); string itemCF = reader.GetString(2); Recommend recommend = new Recommend(); recommend.UserId = userId; recommend.UserCF = userCF; recommend.ItemCF = itemCF; recommendList.Add(recommend); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.CloseAsync(); } return(recommendList); }
/// <summary> /// recommend辅助函数 /// 获取user_id和movie_id的关联字典 /// </summary> /// <param name="user_id"></param> /// <returns></returns> private static PythonDictionary getUserItem(int user_id) { MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select userId,movieId from rating"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Connection.OpenAsync(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); PythonDictionary pyDic = new PythonDictionary(); try { while (reader.Read()) { if (reader.HasRows) { int userId = reader.GetInt32(0); int movieId = reader.GetInt32(1); if (!pyDic.Keys.Contains(userId)) { pyDic.Add(userId, new ArrayList()); } ArrayList subList = pyDic[userId] as ArrayList; subList.Add(movieId); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.CloseAsync(); } return(pyDic); }
public static ArrayList GetAllRating() { ArrayList allRating = new ArrayList(); MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select * from rating"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Connection.Open(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { Rating rating = new Rating(); rating.UserId = reader.GetInt32(0); rating.MovieId = reader.GetInt32(1); rating.Rate = reader.GetFloat(2); int tiemStamp = reader.GetInt32(3); rating.TimeStamp = GetTime(Convert.ToString(tiemStamp)); allRating.Add(rating); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.Close(); } return(allRating); }
public static ArrayList GetRatingByUserId(int user_id) { ArrayList ratingList = new ArrayList(); MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select * from rating where userId = ?us_id"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Parameters.AddWithValue("?us_id", user_id); mySqlCommand.Connection.Open(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { Rating rating = new Rating(); rating.UserId = reader.GetInt32(0); rating.MovieId = reader.GetInt32(1); rating.Rate = reader.GetFloat(2); rating.TimeStamp = GetTime(Convert.ToString(reader.GetInt32(3))); ratingList.Add(rating); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.Close(); } return(ratingList); }
internal static DataBaseProvider GetProvider() { //Read the provider key string dataProvidrString = ConfigurationManager.AppSettings["Provider"]; //Transform string to enum DataBaseProvider dataProvider = DataBaseProvider.None; if (Enum.IsDefined(typeof(DataBaseProvider), dataProvidrString)) { dataProvider = (DataBaseProvider)Enum.Parse(typeof(DataBaseProvider), dataProvidrString); return(dataProvider); } else { return(DataBaseProvider.None); } }
public static ArrayList GetGroupLengthsByMovie() { ArrayList groupLength = new ArrayList(); MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select count(*),movieId from rating group by movieId"; mySqlCommand.Connection.Open(); mySqlCommand.CommandText = sqlStr; MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { Group movieGroup = new Group(); movieGroup.GroupLength = reader.GetInt32(0); movieGroup.Id = reader.GetInt32(1); groupLength.Add(movieGroup); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.Close(); } return(groupLength); }
public static ArrayList GetAllUser() { ArrayList allUser = new ArrayList(); MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select * from user"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Connection.OpenAsync(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { User user = new User(); user.UserId = reader.GetInt32(0); allUser.Add(user); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.CloseAsync(); } return(allUser); }
/// <summary> /// 获取用户ID为user_id相关联的全部电影的ID /// </summary> /// <param name="user_id"></param> /// <returns></returns> private static IronPython.Runtime.List getUserLikeItem(int user_id) { MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select movieId from rating where userId = ?us_id"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Parameters.AddWithValue("?us_id", user_id); mySqlCommand.Connection.OpenAsync(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); IronPython.Runtime.List pyItemList = new List(); try { while (reader.Read()) { if (reader.HasRows) { pyItemList.append(reader.GetInt32(0)); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.CloseAsync(); } return(pyItemList); }
public static User GetUserById(int id) { User user = new User(); MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select * from user where userId = ?us_id"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Parameters.AddWithValue("?us_id", id); mySqlCommand.Connection.Open(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { user.UserId = reader.GetInt32(0); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.Close(); } return(user); }
/// <summary> /// 尺码组明细 /// </summary> /// <returns></returns> public ActionResult chimazumingxi() { QSmartDatabaseClient db = DataBaseProvider.Create("db"); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 1, ChiMaId = 1 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 1, ChiMaId = 2 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 1, ChiMaId = 3 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 1, ChiMaId = 4 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 1, ChiMaId = 5 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 2, ChiMaId = 1 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 2, ChiMaId = 2 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 2, ChiMaId = 3 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 2, ChiMaId = 4 }.CreateQSmartObject()); db.InsertEntity(new ChiMaZuMingXi { ChiMaZuId = 2, ChiMaId = 5 }.CreateQSmartObject()); db.SaveChange(); return(Content("ok")); }
public static string getItemCFRecommend(int user_id) { string itemCF = null; MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select itemCF from recommender where userId = ?us_id"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Parameters.AddWithValue("?us_id", user_id); mySqlCommand.Connection.Open(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { itemCF = reader.GetString(0); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.Close(); } return(itemCF); }
public static int GetRatingTotal() { int ratingTotal = 0; MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = DataBaseProvider.getConnection(); string sqlStr = @"select count(*) from rating"; mySqlCommand.CommandText = sqlStr; mySqlCommand.Connection.Open(); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { ratingTotal = reader.GetInt32(0); } } } catch (Exception e) { throw (e); } finally { mySqlCommand.Connection.Close(); } return(ratingTotal); }
//This method returns a specific adapter object //based on the value of a DataBaseProvider enum public static DbDataAdapter GetDataAdapter(DataBaseProvider dataProvider, string commandText, string connectionString) { DbDataAdapter adapter = null; switch (dataProvider) { case DataBaseProvider.SqlServer: adapter = new SqlDataAdapter(commandText, connectionString); break; case DataBaseProvider.OleDb: adapter = new OleDbDataAdapter(commandText, connectionString); break; case DataBaseProvider.Odbc: adapter = new OdbcDataAdapter(commandText, connectionString); break; default: break; } return(adapter); }
//This method returns a specific parameter object //based on the value of a DataBaseProvider enum public static DbParameter GetParameter(DataBaseProvider dataProvider) { DbParameter parameter = null; switch (dataProvider) { case DataBaseProvider.SqlServer: parameter = new SqlParameter(); break; case DataBaseProvider.OleDb: parameter = new OleDbParameter(); break; case DataBaseProvider.Odbc: parameter = new OdbcParameter(); break; default: break; } return(parameter); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); var connectionString = "Data Source=.;Initial Catalog=NhibernateDB;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; var config = new Configuration(); config.DataBaseIntegration(x => { x.ConnectionString = connectionString; x.Driver <SqlClientDriver>(); x.Dialect <MsSql2008Dialect>(); }); config.AddAssembly(typeof(DataBaseProvider).Assembly.GetName().Name); var sessionFactory = config.BuildSessionFactory(); DataBaseProvider.SetSessionFactory(sessionFactory); }
/// <summary> /// 初始化数据库 /// </summary> /// <param name="Path">链接地址</param> /// <param name="Type">数据库类型</param> /// void IniDB(string Path, DataBaseProvider Type) { dbOperator = DBService.DBOperator.GetInstance(Path, Type); }
/// <summary> /// 初始化数据库 /// </summary> /// <param name="Path">链接地址</param> /// <param name="Type">数据库类型</param> /// void IniDB(string Path, DataBaseProvider Type) { try { dbOperator = DBService.DBOperator.GetInstance(Path, Type); info.DBStatic = "连接正常"; } catch (Exception ex) { WRITELOG.Error(ex.Source.ToString() + "||" + ex.Message.ToString() + "||" + DateTime.Now.ToString(), ex); info.DBStatic = "连接异常"; } }
public DataBase() { _isMono = MiNetServer.IsRunningOnMono(); if(_isMono) { _provider = new DataBaseMono(); } else { _provider = new DataBaseNT(); } LoadAllPerms(); //NT.SQLiteConnection.CreateFile("db.sqlite"); //NT.SQLiteConnection m_dbConnection = new NT.SQLiteConnection("Data Source=db.sqlite;Version=3;"); //m_dbConnection.Open(); //string sql = "CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, nick VARCHAR(64), password VARCHAR(32), role INT)"; //NT.SQLiteCommand command = new NT.SQLiteCommand(sql, m_dbConnection); //command.ExecuteNonQuery(); }