private esProviderSpecificMetadata esAccess(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("ProductID", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("ProductName", new esTypeMap("Text", "System.String")); meta.AddTypeMap("UnitPrice", new esTypeMap("Currency", "System.Decimal")); meta.AddTypeMap("Discontinued", new esTypeMap("Yes/No", "System.Boolean")); meta.Catalog = "ForeignKeyTest.mdb"; meta.Source = "Product"; meta.Destination = "Product"; meta.spInsert = "proc_ProductInsert"; meta.spUpdate = "proc_ProductUpdate"; meta.spDelete = "proc_ProductDelete"; meta.spLoadAll = "proc_ProductLoadAll"; meta.spLoadByPrimaryKey = "proc_ProductLoadByPrimaryKey"; m_providerMetadataMaps["esAccess"] = meta; } return(m_providerMetadataMaps["esAccess"]); }
private esProviderSpecificMetadata esSqlAzure(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("FullName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("DepartmentID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("HireDate", new esTypeMap("datetime", "System.DateTime")); meta.AddTypeMap("Salary", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("IsActive", new esTypeMap("bit", "System.Boolean")); meta.Catalog = "AggregateDB"; meta.Schema = "dbo"; meta.Source = "FullNameView"; meta.Destination = "FullNameView"; meta.spInsert = "proc_FullNameViewInsert"; meta.spUpdate = "proc_FullNameViewUpdate"; meta.spDelete = "proc_FullNameViewDelete"; meta.spLoadAll = "proc_FullNameViewLoadAll"; meta.spLoadByPrimaryKey = "proc_FullNameViewLoadByPrimaryKey"; m_providerMetadataMaps["esSqlAzure"] = meta; } return(m_providerMetadataMaps["esSqlAzure"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("CategoryID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("CategoryName", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("Description", new esTypeMap("ntext", "System.String")); meta.AddTypeMap("Picture", new esTypeMap("image", "System.Byte[]")); meta.Source = "Categories"; meta.Destination = "Categories"; meta.spInsert = "proc_CategoriesInsert"; meta.spUpdate = "proc_CategoriesUpdate"; meta.spDelete = "proc_CategoriesDelete"; meta.spLoadAll = "proc_CategoriesLoadAll"; meta.spLoadByPrimaryKey = "proc_CategoriesLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esVistaDB4(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("CategoryID", new esTypeMap("Int", "System.Int32")); meta.AddTypeMap("CategoryName", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("Description", new esTypeMap("NText", "System.String")); meta.AddTypeMap("Picture", new esTypeMap("Image", "System.Byte[]")); meta.Catalog = "Northwind.vdb4"; meta.Source = "Categories"; meta.Destination = "Categories"; meta.spInsert = "proc_CategoriesInsert"; meta.spUpdate = "proc_CategoriesUpdate"; meta.spDelete = "proc_CategoriesDelete"; meta.spLoadAll = "proc_CategoriesLoadAll"; meta.spLoadByPrimaryKey = "proc_CategoriesLoadByPrimaryKey"; m_providerMetadataMaps["esVistaDB4"] = meta; } return(m_providerMetadataMaps["esVistaDB4"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("TypeID", new esTypeMap("INT UNSIGNED", "System.UInt32")); meta.AddTypeMap("VarCharType", new esTypeMap("VARCHAR", "System.String")); meta.AddTypeMap("TextType", new esTypeMap("TEXT", "System.String")); meta.Catalog = "aggregatedb"; meta.Source = "mysqlunicodetest"; meta.Destination = "mysqlunicodetest"; meta.spInsert = "proc_mysqlunicodetestInsert"; meta.spUpdate = "proc_mysqlunicodetestUpdate"; meta.spDelete = "proc_mysqlunicodetestDelete"; meta.spLoadAll = "proc_mysqlunicodetestLoadAll"; meta.spLoadByPrimaryKey = "proc_mysqlunicodetestLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("UserRoleID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("UserID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("RoleID", new esTypeMap("int", "System.Int32")); meta.Source = "ADefHelpDesk_UserRoles"; meta.Destination = "ADefHelpDesk_UserRoles"; meta.spInsert = "proc_ADefHelpDesk_UserRolesInsert"; meta.spUpdate = "proc_ADefHelpDesk_UserRolesUpdate"; meta.spDelete = "proc_ADefHelpDesk_UserRolesDelete"; meta.spLoadAll = "proc_ADefHelpDesk_UserRolesLoadAll"; meta.spLoadByPrimaryKey = "proc_ADefHelpDesk_UserRolesLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Sid1", new esTypeMap("nchar", "System.String")); meta.AddTypeMap("Sid2", new esTypeMap("nchar", "System.String")); meta.AddTypeMap("Cid1", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("Cid2", new esTypeMap("nchar", "System.String")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "dbo"; meta.Source = "StudentClass"; meta.Destination = "StudentClass"; meta.spInsert = "proc_StudentClassInsert"; meta.spUpdate = "proc_StudentClassUpdate"; meta.spDelete = "proc_StudentClassDelete"; meta.spLoadAll = "proc_StudentClassLoadAll"; meta.spLoadByPrimaryKey = "proc_StudentClassLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esSqlCe(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("GroupID", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("GroupName", new esTypeMap("nvarchar", "System.String")); meta.Catalog = "ForeignKeyTest.sdf"; meta.Source = "CustomerGroup"; meta.Destination = "CustomerGroup"; meta.spInsert = "proc_CustomerGroupInsert"; meta.spUpdate = "proc_CustomerGroupUpdate"; meta.spDelete = "proc_CustomerGroupDelete"; meta.spLoadAll = "proc_CustomerGroupLoadAll"; meta.spLoadByPrimaryKey = "proc_CustomerGroupLoadByPrimaryKey"; m_providerMetadataMaps["esSqlCe"] = meta; } return(m_providerMetadataMaps["esSqlCe"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Id", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("Level", new esTypeMap("nvarchar", "System.String")); meta.Source = "levelMA"; meta.Destination = "levelMA"; meta.spInsert = "proc_levelMAInsert"; meta.spUpdate = "proc_levelMAUpdate"; meta.spDelete = "proc_levelMADelete"; meta.spLoadAll = "proc_levelMALoadAll"; meta.spLoadByPrimaryKey = "proc_levelMALoadByPrimaryKey"; this._providerMetadataMaps["esDefault"] = meta; } return(this._providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esAccess(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("FullName", new esTypeMap("Text", "System.String")); meta.AddTypeMap("DepartmentID", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("HireDate", new esTypeMap("DateTime", "System.DateTime")); meta.AddTypeMap("Salary", new esTypeMap("Decimal", "System.Decimal")); meta.AddTypeMap("IsActive", new esTypeMap("Yes/No", "System.Boolean")); meta.Catalog = "AggregateDb.mdb"; meta.Source = "FullNameView"; meta.Destination = "FullNameView"; meta.spInsert = "proc_FullNameViewInsert"; meta.spUpdate = "proc_FullNameViewUpdate"; meta.spDelete = "proc_FullNameViewDelete"; meta.spLoadAll = "proc_FullNameViewLoadAll"; meta.spLoadByPrimaryKey = "proc_FullNameViewLoadByPrimaryKey"; m_providerMetadataMaps["esAccess"] = meta; } return(m_providerMetadataMaps["esAccess"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("RegionID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("RegionDescription", new esTypeMap("nchar", "System.String")); meta.Source = "Region"; meta.Destination = "Region"; meta.spInsert = "proc_RegionInsert"; meta.spUpdate = "proc_RegionUpdate"; meta.spDelete = "proc_RegionDelete"; meta.spLoadAll = "proc_RegionLoadAll"; meta.spLoadByPrimaryKey = "proc_RegionLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esVistaDB4(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("OrderID", new esTypeMap("Int", "System.Int32")); meta.AddTypeMap("ProductID", new esTypeMap("Int", "System.Int32")); meta.AddTypeMap("UnitPrice", new esTypeMap("Money", "System.Decimal")); meta.AddTypeMap("Quantity", new esTypeMap("SmallInt", "System.Int16")); meta.AddTypeMap("Discount", new esTypeMap("Real", "System.Single")); meta.Catalog = "Northwind.vdb4"; meta.Source = "Order Details"; meta.Destination = "Order Details"; meta.spInsert = "proc_Order DetailsInsert"; meta.spUpdate = "proc_Order DetailsUpdate"; meta.spDelete = "proc_Order DetailsDelete"; meta.spLoadAll = "proc_Order DetailsLoadAll"; meta.spLoadByPrimaryKey = "proc_Order DetailsLoadByPrimaryKey"; m_providerMetadataMaps["esVistaDB4"] = meta; } return(m_providerMetadataMaps["esVistaDB4"]); }
private esProviderSpecificMetadata esMySQL(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Id", new esTypeMap("VARCHAR", "System.String")); meta.AddTypeMap("Notes", new esTypeMap("LONGTEXT", "System.String")); meta.Catalog = "foreignkeytest"; meta.Source = "group"; meta.Destination = "group"; meta.spInsert = "proc_groupInsert"; meta.spUpdate = "proc_groupUpdate"; meta.spDelete = "proc_groupDelete"; meta.spLoadAll = "proc_groupLoadAll"; meta.spLoadByPrimaryKey = "proc_groupLoadByPrimaryKey"; m_providerMetadataMaps["esMySQL"] = meta; } return(m_providerMetadataMaps["esMySQL"]); }
private esProviderSpecificMetadata esPgsql(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("ProductID", new esTypeMap("int8", "System.Int64")); meta.AddTypeMap("ProductName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("UnitPrice", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("Discontinued", new esTypeMap("bool", "System.Boolean")); meta["AutoKeyText"] = @"nextval('""Product_ProductID_seq""'::regclass)"; meta.Catalog = "ForeignKeyTest"; meta.Schema = "public"; meta.Source = "Product"; meta.Destination = "Product"; meta.spInsert = "proc_ProductInsert"; meta.spUpdate = "proc_ProductUpdate"; meta.spDelete = "proc_ProductDelete"; meta.spLoadAll = "proc_ProductLoadAll"; meta.spLoadByPrimaryKey = "proc_ProductLoadByPrimaryKey"; m_providerMetadataMaps["esPgsql"] = meta; } return(m_providerMetadataMaps["esPgsql"]); }
private esProviderSpecificMetadata esPgsql(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("TerritoryID", new esTypeMap("int8", "System.Int64")); meta.AddTypeMap("Description", new esTypeMap("varchar", "System.String")); meta["AutoKeyText"] = @"nextval('""Territory_TerritoryID_seq""'::regclass)"; meta.Catalog = "ForeignKeyTest"; meta.Schema = "public"; meta.Source = "Territory"; meta.Destination = "Territory"; meta.spInsert = "proc_TerritoryInsert"; meta.spUpdate = "proc_TerritoryUpdate"; meta.spDelete = "proc_TerritoryDelete"; meta.spLoadAll = "proc_TerritoryLoadAll"; meta.spLoadByPrimaryKey = "proc_TerritoryLoadByPrimaryKey"; m_providerMetadataMaps["esPgsql"] = meta; } return(m_providerMetadataMaps["esPgsql"]); }
private esProviderSpecificMetadata esSqlAzure(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("EmployeeID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("ReferredID", new esTypeMap("int", "System.Int32")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "dbo"; meta.Source = "ReferredEmployee"; meta.Destination = "ReferredEmployee"; meta.spInsert = "proc_ReferredEmployeeInsert"; meta.spUpdate = "proc_ReferredEmployeeUpdate"; meta.spDelete = "proc_ReferredEmployeeDelete"; meta.spLoadAll = "proc_ReferredEmployeeLoadAll"; meta.spLoadByPrimaryKey = "proc_ReferredEmployeeLoadByPrimaryKey"; m_providerMetadataMaps["esSqlAzure"] = meta; } return(m_providerMetadataMaps["esSqlAzure"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("ConstructorTestId", new esTypeMap("bigint", "System.Int64")); meta.AddTypeMap("DefaultInt", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("DefaultBool", new esTypeMap("bit", "System.Boolean")); meta.AddTypeMap("DefaultDateTime", new esTypeMap("datetime", "System.DateTime")); meta.AddTypeMap("DefaultString", new esTypeMap("varchar", "System.String")); meta.Catalog = "AggregateDb"; meta.Schema = "dbo"; meta.Source = "ConstructorTest"; meta.Destination = "ConstructorTest"; meta.spInsert = "proc_ConstructorTestInsert"; meta.spUpdate = "proc_ConstructorTestUpdate"; meta.spDelete = "proc_ConstructorTestDelete"; meta.spLoadAll = "proc_ConstructorTestLoadAll"; meta.spLoadByPrimaryKey = "proc_ConstructorTestLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esOracle(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("TestId", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("DefaultNotNullInt", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("DefaultNotNullBool", new esTypeMap("NUMBER", "System.Decimal")); meta["AutoKeyText"] = "DEFAULTTEST_SEQ"; meta.Catalog = "ENTITYSPACES"; meta.Schema = "ENTITYSPACES"; meta.Source = "DefaultTest"; meta.Destination = "DefaultTest"; meta.spInsert = "esDefaultTestInsert"; meta.spUpdate = "esDefaultTestUpdate"; meta.spDelete = "esDefaultTestDelete"; meta.spLoadAll = "esDefaultTestLoadAll"; meta.spLoadByPrimaryKey = "esDefaultTestLoadByPK"; m_providerMetadataMaps["esOracle"] = meta; } return(m_providerMetadataMaps["esOracle"]); }
private esProviderSpecificMetadata esSQLite(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("OrderID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("ProductID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("UnitPrice", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("Quantity", new esTypeMap("smallint", "System.Int16")); meta.AddTypeMap("Discount", new esTypeMap("real", "System.Single")); meta.Catalog = "main"; meta.Source = "Order Details"; meta.Destination = "Order Details"; meta.spInsert = "proc_Order DetailsInsert"; meta.spUpdate = "proc_Order DetailsUpdate"; meta.spDelete = "proc_Order DetailsDelete"; meta.spLoadAll = "proc_Order DetailsLoadAll"; meta.spLoadByPrimaryKey = "proc_Order DetailsLoadByPrimaryKey"; m_providerMetadataMaps["esSQLite"] = meta; } return(m_providerMetadataMaps["esSQLite"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("EmployeeID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("TerritoryID", new esTypeMap("nvarchar", "System.String")); meta.Catalog = "Northwind"; meta.Schema = "dbo"; meta.Source = "EmployeeTerritories"; meta.Destination = "EmployeeTerritories"; meta.spInsert = "proc_EmployeeTerritoriesInsert"; meta.spUpdate = "proc_EmployeeTerritoriesUpdate"; meta.spDelete = "proc_EmployeeTerritoriesDelete"; meta.spLoadAll = "proc_EmployeeTerritoriesLoadAll"; meta.spLoadByPrimaryKey = "proc_EmployeeTerritoriesLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("CustomerTypeID", new esTypeMap("nchar", "System.String")); meta.AddTypeMap("CustomerDesc", new esTypeMap("ntext", "System.String")); meta.Source = "CustomerDemographics"; meta.Destination = "CustomerDemographics"; meta.spInsert = "proc_CustomerDemographicsInsert"; meta.spUpdate = "proc_CustomerDemographicsUpdate"; meta.spDelete = "proc_CustomerDemographicsDelete"; meta.spLoadAll = "proc_CustomerDemographicsLoadAll"; meta.spLoadByPrimaryKey = "proc_CustomerDemographicsLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("ProductID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("ProductName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("UnitPrice", new esTypeMap("money", "System.Decimal")); meta.AddTypeMap("Discontinued", new esTypeMap("bit", "System.Boolean")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "dbo"; meta.Source = "Product"; meta.Destination = "Product"; meta.spInsert = "proc_ProductInsert"; meta.spUpdate = "proc_ProductUpdate"; meta.spDelete = "proc_ProductDelete"; meta.spLoadAll = "proc_ProductLoadAll"; meta.spLoadByPrimaryKey = "proc_ProductLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esSqlAzure(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("SomeText", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("TheKey", new esTypeMap("int", "System.Int32")); meta.Catalog = "AggregateDB"; meta.Schema = "dbo"; meta.Source = "KeyNotFirst"; meta.Destination = "KeyNotFirst"; meta.spInsert = "proc_KeyNotFirstInsert"; meta.spUpdate = "proc_KeyNotFirstUpdate"; meta.spDelete = "proc_KeyNotFirstDelete"; meta.spLoadAll = "proc_KeyNotFirstLoadAll"; meta.spLoadByPrimaryKey = "proc_KeyNotFirstLoadByPrimaryKey"; m_providerMetadataMaps["esSqlAzure"] = meta; } return(m_providerMetadataMaps["esSqlAzure"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("IdentityKey", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("ItemDescription", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("timestamp", "System.Byte[]")); meta.AddTypeMap("GuidNewid", new esTypeMap("uniqueidentifier", "System.Guid")); meta.Catalog = "AggregateDb"; meta.Schema = "dbo"; meta.Source = "Naming Test2"; meta.Destination = "Naming Test2"; meta.spInsert = "proc_Naming Test2Insert"; meta.spUpdate = "proc_Naming Test2Update"; meta.spDelete = "proc_Naming Test2Delete"; meta.spLoadAll = "proc_Naming Test2LoadAll"; meta.spLoadByPrimaryKey = "proc_Naming Test2LoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esSybase(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("EmpID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("TerrID", new esTypeMap("integer", "System.Int32")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "DBA"; meta.Source = "EmployeeTerritory"; meta.Destination = "EmployeeTerritory"; meta.spInsert = "proc_EmployeeTerritoryInsert"; meta.spUpdate = "proc_EmployeeTerritoryUpdate"; meta.spDelete = "proc_EmployeeTerritoryDelete"; meta.spLoadAll = "proc_EmployeeTerritoryLoadAll"; meta.spLoadByPrimaryKey = "proc_EmployeeTerritoryLoadByPrimaryKey"; m_providerMetadataMaps["esSybase"] = meta; } return(m_providerMetadataMaps["esSybase"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("OrderID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("ProductID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("UnitPrice", new esTypeMap("money", "System.Decimal")); meta.AddTypeMap("Quantity", new esTypeMap("smallint", "System.Int16")); meta.AddTypeMap("Discount", new esTypeMap("real", "System.Single")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "dbo"; meta.Source = "OrderItem"; meta.Destination = "OrderItem"; meta.spInsert = "proc_OrderItemInsert"; meta.spUpdate = "proc_OrderItemUpdate"; meta.spDelete = "proc_OrderItemDelete"; meta.spLoadAll = "proc_OrderItemLoadAll"; meta.spLoadByPrimaryKey = "proc_OrderItemLoadByPrimaryKey"; this.m_providerMetadataMaps["esDefault"] = meta; } return(this.m_providerMetadataMaps["esDefault"]); }
private esProviderSpecificMetadata esOracle(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("CharType", new esTypeMap("CHAR", "System.String")); meta.AddTypeMap("VarCharType", new esTypeMap("VARCHAR2", "System.String")); meta.AddTypeMap("DateType", new esTypeMap("DATE", "System.DateTime")); meta.AddTypeMap("IntegerType", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("SmallIntType", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("DecimalType", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("FloatType", new esTypeMap("FLOAT", "System.Decimal")); meta.AddTypeMap("DoubleType", new esTypeMap("FLOAT", "System.Decimal")); meta.AddTypeMap("RealType", new esTypeMap("FLOAT", "System.Decimal")); meta.AddTypeMap("NumberType", new esTypeMap("NUMBER", "System.Decimal")); meta.Catalog = "ENTITYSPACES"; meta.Schema = "ENTITYSPACES"; meta.Source = "OracleDataTypes"; meta.Destination = "OracleDataTypes"; meta.spInsert = "esOracleDataTypesInsert"; meta.spUpdate = "esOracleDataTypesUpdate"; meta.spDelete = "esOracleDataTypesDelete"; meta.spLoadAll = "esOracleDataTypesLoadAll"; meta.spLoadByPrimaryKey = "esOracleDataTypesLoadByPK"; m_providerMetadataMaps["esOracle"] = meta; } return(m_providerMetadataMaps["esOracle"]); }
private esProviderSpecificMetadata esSybase(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("ProductID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("ProductName", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("SupplierID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("CategoryID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("QuantityPerUnit", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("UnitPrice", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("UnitsInStock", new esTypeMap("smallint", "System.Int16")); meta.AddTypeMap("UnitsOnOrder", new esTypeMap("smallint", "System.Int16")); meta.AddTypeMap("ReorderLevel", new esTypeMap("smallint", "System.Int16")); meta.AddTypeMap("Discontinued", new esTypeMap("bit", "System.Boolean")); meta.Catalog = "Northwind"; meta.Schema = "DBA"; meta.Source = "Products"; meta.Destination = "Products"; meta.spInsert = "proc_ProductsInsert"; meta.spUpdate = "proc_ProductsUpdate"; meta.spDelete = "proc_ProductsDelete"; meta.spLoadAll = "proc_ProductsLoadAll"; meta.spLoadByPrimaryKey = "proc_ProductsLoadByPrimaryKey"; m_providerMetadataMaps["esSybase"] = meta; } return(m_providerMetadataMaps["esSybase"]); }
private esProviderSpecificMetadata esSQLite(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("ShipperID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("CompanyName", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("Phone", new esTypeMap("nvarchar", "System.String")); meta.Catalog = "main"; meta.Source = "Shippers"; meta.Destination = "Shippers"; meta.spInsert = "proc_ShippersInsert"; meta.spUpdate = "proc_ShippersUpdate"; meta.spDelete = "proc_ShippersDelete"; meta.spLoadAll = "proc_ShippersLoadAll"; meta.spLoadByPrimaryKey = "proc_ShippersLoadByPrimaryKey"; m_providerMetadataMaps["esSQLite"] = meta; } return(m_providerMetadataMaps["esSQLite"]); }
private esProviderSpecificMetadata esAccess(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("EmployeeID", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("LastName", new esTypeMap("Text", "System.String")); meta.AddTypeMap("FirstName", new esTypeMap("Text", "System.String")); meta.AddTypeMap("Supervisor", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("Age", new esTypeMap("Long", "System.Int32")); meta.Catalog = "ForeignKeyTest.mdb"; meta.Source = "Employee"; meta.Destination = "Employee"; meta.spInsert = "proc_EmployeeInsert"; meta.spUpdate = "proc_EmployeeUpdate"; meta.spDelete = "proc_EmployeeDelete"; meta.spLoadAll = "proc_EmployeeLoadAll"; meta.spLoadByPrimaryKey = "proc_EmployeeLoadByPrimaryKey"; m_providerMetadataMaps["esAccess"] = meta; } return(m_providerMetadataMaps["esAccess"]); }