Exemple #1
0
        /// <summary>
        /// 根据Provider字符串获取数据类型
        /// </summary>
        /// <param name="provider"></param>
        /// <returns></returns>
        public static DatabaseType GetDatabaseType(string provider)
        {
            DatabaseType dbType = DatabaseType.None;

            provider = provider.ToLower();
            if (provider == SQLServer.ToLower() || provider == SQLAzure.ToLower())
            {
                dbType = DatabaseType.SqlServer;
            }
            else if (provider == SqlServerCe.ToLower() || provider == SqlServerCe40.ToLower())
            {
                dbType = DatabaseType.SqlCe;
            }
            else if (provider == SQLite.ToLower())
            {
                dbType = DatabaseType.SQLite;
            }

            else if (provider == MySql.ToLower())
            {
                dbType = DatabaseType.MySql;
            }
            else if (provider == Oracle.ToLower())
            {
                dbType = DatabaseType.Oracle;
            }
            else if (provider == OracleDataAccess.ToLower())
            {
                dbType = DatabaseType.Oracle;
            }
            else if (provider == OracleManagedDataAccess.ToLower())
            {
                dbType = DatabaseType.Oracle;
            }
            else if (provider == Access.ToLower())
            {
                dbType = DatabaseType.Access;
            }
            else if (provider == OleDb.ToLower())
            {
                dbType = DatabaseType.OleDb;
            }
            else if (provider == Odbc.ToLower())
            {
                dbType = DatabaseType.OleDb;
            }
            else if (provider == PostgreSQL.ToLower())
            {
                dbType = DatabaseType.PostgreSQL;
            }
            else if (provider == DB2.ToLower())
            {
                dbType = DatabaseType.DB2;
            }
            else if (provider == FirebirdSql.ToLower())
            {
                dbType = DatabaseType.Firebird;
            }
            else if (provider == SybaseASA.ToLower())
            {
                dbType = DatabaseType.SybaseASA;
            }
            else if (provider == SybaseASE.ToLower())
            {
                dbType = DatabaseType.SybaseASE;
            }
            else if (provider == SybaseUltraLite.ToLower())
            {
                dbType = DatabaseType.SybaseUltraLite;
            }
            else if (provider == DM.ToLower())
            {
                dbType = DatabaseType.DM;
            }
            return(dbType);
        }