示例#1
0
        private static IComparable getShardColumnValueByParameters(String logicDbName, IList <String> shardColumns, StatementParameterCollection parameters, Boolean quote = true)
        {
            IComparable shardColumnValue = null;

            if (shardColumns == null || shardColumns.Count == 0)
            {
                return(shardColumnValue);
            }

            if (parameters == null || parameters.Count == 0)
            {
                return(shardColumnValue);
            }

            DbDialect dbDialect = null;

            if (quote)
            {
                dbDialect = DbDialectFactory.Build(DALBootstrap.GetProviderType(logicDbName));
            }

            IDictionary <String, StatementParameter> dict = new Dictionary <String, StatementParameter>();

            foreach (var item in parameters)
            {
                String parameterName = item.Name;

                if (String.IsNullOrEmpty(parameterName))
                {
                    continue;
                }

                parameterName = parameterName.ToLower();

                if (!dict.ContainsKey(parameterName))
                {
                    dict.Add(parameterName, item);
                }
            }

            foreach (var item in shardColumns)
            {
                String name = quote ? dbDialect.QuoteParameter(item.ToLower()) : item.ToLower();

                if (dict.ContainsKey(name))
                {
                    shardColumnValue = dict[name].Value as IComparable;
                    break;
                }
            }

            return(shardColumnValue);
        }
示例#2
0
        /// <summary>
        /// 获取方言DAO,请注意返回null的情况
        /// </summary>
        /// <param name="logicDbName"></param>
        /// <returns>IDialectDao</returns>
        public static IDialectDao CreateDialectDao(String logicDbName)
        {
            return(DialectDaos.GetOrAdd(logicDbName, key =>
            {
                var providerType = DALBootstrap.GetProviderType(logicDbName);
                switch (providerType)
                {
                case DatabaseProviderType.MySql:
                    return new MySqlDialectDao(key);

                default:
                    return null;
                }
            }));
        }
示例#3
0
        /// <summary>
        /// 获取HA对象
        /// </summary>
        /// <param name="logicDbName"></param>
        /// <returns></returns>
        public static IHA GetInstance(String logicDbName)
        {
            var providerType = DALBootstrap.GetProviderType(logicDbName);

            switch (providerType)
            {
            case DatabaseProviderType.SqlServer:
                return(new SqlServerHA());

            case DatabaseProviderType.MySql:
                return(new MySqlHA());

            default:
                throw new NotImplementedException("Not supported.");
            }
        }