Exemple #1
0
        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);
        }
Exemple #2
0
 /// <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);
     }
 }
Exemple #3
0
        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);
        }
Exemple #5
0
        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();
        }
Exemple #6
0
 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;
 }
Exemple #7
0
 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;
 }
Exemple #8
0
    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;
            }
        }
    }
Exemple #9
0
        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();
            }
        }
Exemple #10
0
        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;
        }
Exemple #11
0
        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;
        }