public static DBConnection CreateInstance(
			DBServerTypes dbServerType_in, 
			string connectionString_in, 
			string logFile_in
		) {
			switch (dbServerType_in) {
#if PostgreSQL
				case DBServerTypes.PostgreSQL:
					return new DBConnection_PostgreSQL(
						connectionString_in, 
						logFile_in
					);
#endif
				case DBServerTypes.SQLServer:
					return new DBConnection_SQLServer(
						connectionString_in, 
						logFile_in
					);
#if MySQL
				case DBServerTypes.MySQL:
					return new DBConnection_MySQL(
						connectionString_in, 
						logFile_in
					);
#endif
			}
			
			throw new Exception(
				string.Format(
					"unsuported db type: {0}", 
					dbServerType_in.ToString()
				)
			);
		}
Exemple #2
0
//		public static DBUtilities GetInstance(
//			string dbServerType_in
//		) {
//			return GetInstance(
//				(DBServerTypes)Enum.Parse(typeof(DBServerTypes), dbServerType_in)
//			);
//		}
        public static DBUtilities GetInstance(
            DBServerTypes dbServerType_in
            )
        {
            switch (dbServerType_in)
            {
#if PostgreSQL
            case DBServerTypes.PostgreSQL:
                return(dbUtilities_PostgreSQL);
#endif
#if MySQL
            case DBServerTypes.MySQL:
                return(dbUtilities_MySQL);
#endif
            case DBServerTypes.SQLServer:
                return(dbUtilities_SQLServer);
            }

            throw new Exception(
                      string.Format(
                          System.Globalization.CultureInfo.CurrentCulture,
                          "unsuported db type: {0}",
                          dbServerType_in.ToString()
                          )
                      );
        }
Exemple #3
0
        public static DBUtils GetInstance(
            DBServerTypes dbServerType_in
            )
        {
            switch (dbServerType_in)
            {
#if PostgreSQL
            case DBServerTypes.PostgreSQL:
                return(dbUtils_PostgreSQL);
#endif
#if MySQL
            case DBServerTypes.MySQL:
                return(dbUtils_MySQL);
#endif
            case DBServerTypes.SQLServer:
                return(dbUtils_SQLServer);
            }

            throw new Exception(
                      string.Format(
                          "unsuported db type: {0}",
                          dbServerType_in.ToString()
                          )
                      );
        }
Exemple #4
0
        public int Search(
            DBServerTypes dbServerType_in
            )
        {
            for (int i = 0; i < this.cols_.Count; i++)
            {
                if (
                    (
                                                #if NET_1_1
                        ((XS_tableFieldDBType)cols_[i])
                                                #else
                        this.cols_[i]
                                                #endif
                        .DBServerType
                        ==
                        dbServerType_in.ToString()
                    )

                    )
                {
                    return(i);
                }
            }

            return(-1);
        }
Exemple #5
0
                                       public static DBConnection CreateInstance(
                                           DBServerTypes dbServerType_in,
                                           string connectionString_in,
                                           string logFile_in
                                           )
                                       {
                                           switch (dbServerType_in)
                                           {
#if PostgreSQL
                                           case DBServerTypes.PostgreSQL:
                                               return(new DBConnection_PostgreSQL(
                                                          connectionString_in,
                                                          logFile_in
                                                          ));
#endif
                                           case DBServerTypes.SQLServer:
                                               return(new DBConnection_SQLServer(
                                                          connectionString_in,
                                                          logFile_in
                                                          ));

#if MySQL
                                           case DBServerTypes.MySQL:
                                               return(new DBConnection_MySQL(
                                                          connectionString_in,
                                                          logFile_in
                                                          ));
#endif
                                           }

                                           throw new Exception(
                                                     string.Format(
                                                         System.Globalization.CultureInfo.CurrentCulture,
                                                         "unsuported db type: {0}",
                                                         dbServerType_in.ToString()
                                                         )
                                                     );
                                       }
		public int Search(
			DBServerTypes dbServerType_in
		) {
			for (int i = 0; i < cols_.Count; i++) {
				if (
					(
						#if NET_1_1
						((XS_tableFieldDBType)cols_[i])
						#else
						cols_[i]
						#endif
							.DBServerType
						==
						dbServerType_in.ToString()
					)
					
				) {
					return i;
				}
			}

			return -1;
		}
		public static DBUtils GetInstance(
			DBServerTypes dbServerType_in
		) {
			switch (dbServerType_in) {
#if PostgreSQL
				case DBServerTypes.PostgreSQL:
					return dbUtils_PostgreSQL;
#endif
#if MySQL
				case DBServerTypes.MySQL:
					return dbUtils_MySQL;
#endif
				case DBServerTypes.SQLServer:
					return dbUtils_SQLServer;
			}
			
			throw new Exception(
				string.Format(
					"unsuported db type: {0}", 
					dbServerType_in.ToString()
				)
			);
		}
Exemple #8
0
//		public static DBUtilities GetInstance(
//			string dbServerType_in
//		) {
//			return GetInstance(
//				(DBServerTypes)Enum.Parse(typeof(DBServerTypes), dbServerType_in)
//			);
//		}
		public static DBUtilities GetInstance(
			DBServerTypes dbServerType_in
		) {
			switch (dbServerType_in) {
#if PostgreSQL
				case DBServerTypes.PostgreSQL:
					return dbUtilities_PostgreSQL;
#endif
#if MySQL
				case DBServerTypes.MySQL:
					return dbUtilities_MySQL;
#endif
				case DBServerTypes.SQLServer:
					return dbUtilities_SQLServer;
			}
			
			throw new Exception(
				string.Format(
					System.Globalization.CultureInfo.CurrentCulture,
					"unsuported db type: {0}", 
					dbServerType_in.ToString()
				)
			);
		}