private static ISqlBuilderFluentAdapter GetInstanceSqlAdapter(SqlAdapterType sqlAdapterType) { ISqlBuilderFluentAdapter sqlAdapter; switch (sqlAdapterType) { case SqlAdapterType.SqlServer2008: sqlAdapter = new SqlServer2008Adapter(); break; case SqlAdapterType.SqlServer2012: case SqlAdapterType.SqlServer2014: case SqlAdapterType.SqlServer2016: case SqlAdapterType.SqlServer2017: case SqlAdapterType.SqlServer2019: sqlAdapter = new SqlServerGreaterEqual2012Adapter(); break; case SqlAdapterType.MySql: sqlAdapter = new MySqlAdapter(); break; default: throw new SqlBuilderException("'SqlAdapterType' not defined"); } return(sqlAdapter); }
/// <summary> /// 创建数据库适配器对象,执行用户自定义方法 /// </summary> /// <param name="cmd_str">数据库命令字符串</param> /// <param name="conn">连接的数据库对象</param> /// <param name="callback">用户自定义方法</param> public static void SetMySqlDataAdapter(string cmd_str, MySqlConnection conn, ref MySqlAdapter uadapter, AdapterCallBack callback) { lock (conn) { MySqlDataAdapter adapter = new MySqlDataAdapter(cmd_str, conn); uadapter.adapter = adapter; callback(ref uadapter); } }
private void Prepare() { var adaper = new MySqlAdapter(); adaper.Settings.Visitters.Add(new ConvertVisitter()); DbConnectionManager.AddAdapter(adaper); DbConnectionManager.AddProvider <DapperProvider>(); }
//Aqui é onde o programa inicia public static void Main(string[] args) { var sqlServer = new SqlServerAdapter(); var mySql = new MySqlAdapter(); var admin = new AdministradorVendas(); admin.FecharCaixa(sqlServer); admin.FecharCaixa(mySql); }
public void TestMethod8() { //IQueryable<UserCenter.DataModel.DB_User> query = new MarkQueryable<UserCenter.DataModel.DB_User>(); //query = query.Where(en => en.DataStatus == 1); //query = query.Where(en => en.ID == 1); //var list = query.ToList(); IoCFac.Instance.LoadAssembly("UnitTestProject1"); var sqlAdapter = new MySqlAdapter(); var groupid = sqlAdapter.Query <DB_UserGroup>(en => en.UserID == 1 && en.DataStatus == (int)DataStatus.Normal).Select(en => en.GroupID).ToList(); var groups = sqlAdapter.Query <DB_Group>(en => groupid.Contains(en.ID) && en.DataStatus == (int)DataStatus.Normal).ToList(); }
public Adapter createAdapter(string db,string Host,string Username,string Password,int Port,string Catalog) { Adapter adapter = null; switch (db.ToLower().Trim()) { case "mssql": adapter = new MsSqlAdapter(Host, Username, Password, Port, Catalog); break; case "mysql": default: adapter = new MySqlAdapter(Host, Username, Password, Port, Catalog); break; } return adapter; }
public Adapter createAdapter(string db) { Adapter adapter = null; switch (db.ToLower()) { case "mssql": adapter = new MsSqlAdapter(); break; case "mysql": default: adapter = new MySqlAdapter(); break; } return adapter; }
public static void Main(string [] args) { string [] databases = null; if (args.Length == 0 || (args.Length == 1 && args [0].Equals("all"))) { // Run test for all databases string listOfDbs = ConfigurationSettings.AppSettings ["Databases"]; databases = listOfDbs.Split(';'); } else { databases = (string [])args.Clone(); } BaseAdapter dbAdapter = null; foreach (string str in databases) { switch (str) { case "mysql": Console.WriteLine("\n ****** Running tests for MYSQL ***** \n"); dbAdapter = new MySqlAdapter("mysql"); dbAdapter.RunTest(); break; case "mssql": Console.WriteLine("\n ****** Running tests for MS SQL ***** \n"); dbAdapter = new MsSqlAdapter("mssql"); dbAdapter.RunTest(); break; case "oracle": Console.WriteLine("\n ****** Running tests for ORACLE ***** \n"); dbAdapter = new OraAdapter("oracle"); dbAdapter.RunTest(); break; case "postgres": Console.WriteLine("\n ****** Running tests for POSTGRE ***** \n"); dbAdapter = new PostgresAdapter("postgres"); dbAdapter.RunTest(); break; } } }
public void CreateAdapterFromFileTest() { if (!File.Exists("connections.config")) { //write config file format "connection_name":"connection string" File.WriteAllText("connections.config", "\"test_connection\":\"User Id = test; Password = test; Host = localhost; Character Set = utf8;\""); } try { adapter = new MySqlAdapter("test_connection", "connections.config"); } catch (Exception) { Assert.Fail(); } }
public Injector(string facility, string host, string username, string password, int LoggedInUserId, string User, string UserType, string schema = "") { MySqlAdapter databaseAdapter; if (string.IsNullOrEmpty(schema)) { databaseAdapter = new MySqlAdapter(host, username, password); } else { databaseAdapter = new MySqlAdapter(host, username, password, schema); } _databaseSettings = new DatabaseSettings(databaseAdapter); _facility = facility; _loggedInId = LoggedInUserId; _username = User; _userType = UserType; }
public JxcFlowCellItem Get(ushort eId, string cellNumber) { var flowCell = new JxcFlowCellItem(); var pg = new PredicateGroup { Operator = GroupOperator.Or, Predicates = new List <IPredicate>() }; pg.Predicates.Add(Predicates.Field <JxcFlowCellItem>(f => f.cell_number, Operator.Eq, cellNumber)); IList <ISort> sorts = new List <ISort>(); ISort sort = new Sort(); sort.Ascending = false; sort.PropertyName = "cell_number"; //如果有Map,则此次要填写Map对象的字段名称,而不是数据库表字段名称 sorts.Add(sort); string connStr = "Server=rm-bp1gut3b938v3tms1.mysql.rds.aliyuncs.com;Port=3306;initial catalog=erp;uid=jijiuser;pwd=Fxft2016;Allow User Variables=True"; MySqlAdapter mySqlClient = new MySqlAdapter(connStr); flowCell = mySqlClient.Get <JxcFlowCellItem>(pg, sorts).FirstOrDefault(); return(flowCell); }
public void Initialize() { adapter = new MySqlAdapter("User Id=test; Password=test; Host=localhost;Character Set=utf8;"); adapter.Error += Adapter_Error; }
public static ReaderAdapter Create(SchemaParameters schemaParameters) { ReaderAdapter schemaReader = null; switch (schemaParameters.SqlType) { case SqlType.SqlServer: return new SqlServerAdapter(schemaParameters); case SqlType.Oracle: schemaReader = new OracleAdapter(schemaParameters); break; case SqlType.SQLite: schemaReader = new SqLiteAdapter(schemaParameters); break; case SqlType.PostgreSql: schemaReader = new PostgreSqlAdapter(schemaParameters); break; case SqlType.MySql: schemaReader = new MySqlAdapter(schemaParameters); break; case SqlType.SqlServerCe: schemaReader = new SqlServerCeAdapter(schemaParameters); break; default: //var providerName = schemaParameters.ProviderName; //all the other types //if (providerName.Equals("Ingres.Client", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new IngresSchemaReader(connectionString, providerName); //} //else if (providerName.Equals("iAnyWhere.Data.SQLAnyWhere", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new SybaseAsaSchemaReader(connectionString, providerName); //} //else if (providerName.Equals("Sybase.Data.AseClient", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new SybaseAseSchemaReader(connectionString, providerName); //} //else if (providerName.Equals("iAnyWhere.Data.UltraLite", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new SybaseUltraLiteSchemaReader(connectionString, providerName); //} //else if (providerName.Equals("System.Data.OleDb", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new OleDbSchemaReader(connectionString, providerName); //} //else if (providerName.Equals("System.Data.VistaDB", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new VistaDbSchemaReader(connectionString, providerName); //} //else if (providerName.Equals("IBM.Data.DB2.iSeries", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new Db2ISeriesSchemaReader(connectionString, providerName); //} //else if (providerName.Equals("FirebirdSql.Data.FirebirdClient", StringComparison.OrdinalIgnoreCase)) //{ // schemaReader = new FirebirdSqlSchemaReader(connectionString, providerName); //} break; } if (schemaReader == null) { #if !COREFX schemaReader = new DbProviderReaderAdapter(schemaParameters); #else schemaReader = new ReaderAdapter(schemaParameters); #endif } return schemaReader; }