Exemplo n.º 1
0
        public static DatabaseProperty GetDatabaseProperty(string name)
        {
            DatabaseConnection            reader = default(DatabaseConnection);
            List <connectionStringEntity> list   = JsonConfigMange.GetInstance().Settings <List <connectionStringEntity> >(dbPath);

            connectionStringEntity readerconnetionInfo = list.Find(item => item.name == (name + ".Reader"));
            connectionStringEntity writerconnetionInfo = list.Find(item => item.name == (name + ".Writer"));

            reader.DatabaseType = DatabaseType.MSSQLServer;

            if (readerconnetionInfo == null)
            {
                reader.ConnectionString = string.Empty;
            }
            else
            {
                reader.ConnectionString = readerconnetionInfo.value;
                reader.DatabaseType     = DbProvider.GetType(readerconnetionInfo.dbType);
            }
            DatabaseConnection writer = default(DatabaseConnection);

            writer.DatabaseType = DatabaseType.MSSQLServer;

            if (writerconnetionInfo == null)
            {
                writer.ConnectionString = string.Empty;
            }
            else
            {
                writer.ConnectionString = writerconnetionInfo.value;
                writer.DatabaseType     = DbProvider.GetType(writerconnetionInfo.dbType);
            }
            return(new DatabaseProperty(reader, writer));
        }
        public static DatabaseProperty GetDatabaseProperty(string name)
        {
            DatabaseConnection reader = default(DatabaseConnection);

            reader.DatabaseType = DatabaseType.MSSQLServer;


            ConnectionStringSettings connectionStringSettings = Configsetting.Appsettings.DbConnection(name + ".Reader");

            if (connectionStringSettings == null)
            {
                reader.ConnectionString = string.Empty;
            }
            else
            {
                reader.ConnectionString = connectionStringSettings.ConnectionString;
                reader.DatabaseType     = DbProvider.GetType(connectionStringSettings.ProviderName);
                if ((!string.IsNullOrEmpty(connectionStringSettings.ProviderName)) && connectionStringSettings.ProviderName.Contains("2012"))
                {
                    reader.Version = 2012;
                }
            }
            DatabaseConnection writer = default(DatabaseConnection);

            writer.DatabaseType = DatabaseType.MSSQLServer;
            writer.Version      = 2008;
            ConnectionStringSettings connectionStringSettings2 = Configsetting.Appsettings.DbConnection(name + ".Writer");

            if (connectionStringSettings2 == null)
            {
                writer.ConnectionString = string.Empty;
            }
            else
            {
                writer.ConnectionString = connectionStringSettings2.ConnectionString;
                writer.DatabaseType     = DbProvider.GetType(connectionStringSettings.ProviderName);
                if ((!string.IsNullOrEmpty(connectionStringSettings2.ProviderName)) && connectionStringSettings2.ProviderName.Contains("2012"))
                {
                    writer.Version = 2012;
                }
            }
            return(new DatabaseProperty(reader, writer));
        }