private esProviderSpecificMetadata esSqlCe(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Id", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("NumericType", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("RealType", new esTypeMap("real", "System.Single")); meta.AddTypeMap("FloatType", new esTypeMap("float", "System.Double")); meta.Catalog = "AggregateDb.sdf"; meta.Source = "SqlCeDataTypes"; meta.Destination = "SqlCeDataTypes"; meta.spInsert = "proc_SqlCeDataTypesInsert"; meta.spUpdate = "proc_SqlCeDataTypesUpdate"; meta.spDelete = "proc_SqlCeDataTypesDelete"; meta.spLoadAll = "proc_SqlCeDataTypesLoadAll"; meta.spLoadByPrimaryKey = "proc_SqlCeDataTypesLoadByPrimaryKey"; m_providerMetadataMaps["esSqlCe"] = meta; } return m_providerMetadataMaps["esSqlCe"]; }
private esProviderSpecificMetadata esSybase(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("float", "System.Single")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "DBA"; 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"; m_providerMetadataMaps["esSybase"] = meta; } return m_providerMetadataMaps["esSybase"]; }
private esProviderSpecificMetadata esVistaDB4(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Id", new esTypeMap("Char", "System.String")); meta.AddTypeMap("Name", new esTypeMap("VarChar", "System.String")); meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("BigInt", "System.Int64")); meta.Catalog = "AggregateDb.vdb4"; meta.Source = "ConcurrencyTest"; meta.Destination = "ConcurrencyTest"; meta.spInsert = "proc_ConcurrencyTestInsert"; meta.spUpdate = "proc_ConcurrencyTestUpdate"; meta.spDelete = "proc_ConcurrencyTestDelete"; meta.spLoadAll = "proc_ConcurrencyTestLoadAll"; meta.spLoadByPrimaryKey = "proc_ConcurrencyTestLoadByPrimaryKey"; 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("CHAR", "System.String")); meta.AddTypeMap("Name", new esTypeMap("VARCHAR", "System.String")); meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("BIGINT", "System.Int64")); meta.Catalog = "aggregatedb"; meta.Source = "concurrencytest"; meta.Destination = "concurrencytest"; meta.spInsert = "proc_concurrencytestInsert"; meta.spUpdate = "proc_concurrencytestUpdate"; meta.spDelete = "proc_concurrencytestDelete"; meta.spLoadAll = "proc_concurrencytestLoadAll"; meta.spLoadByPrimaryKey = "proc_concurrencytestLoadByPrimaryKey"; m_providerMetadataMaps["esMySQL"] = meta; } return m_providerMetadataMaps["esMySQL"]; }
private esProviderSpecificMetadata esSqlCe4(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("TerritoryID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("Description", new esTypeMap("nvarchar", "System.String")); meta.Catalog = "ForeignKeyTest.sdf"; 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["esSqlCe4"] = meta; } return m_providerMetadataMaps["esSqlCe4"]; }
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 = "ForeignKeyTest.vdb4"; 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"; m_providerMetadataMaps["esVistaDB4"] = meta; } return m_providerMetadataMaps["esVistaDB4"]; }
private esProviderSpecificMetadata esPgsql(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("EmployeeID", new esTypeMap("int8", "System.Int64")); meta.AddTypeMap("ReferredID", new esTypeMap("int8", "System.Int64")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "public"; 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["esPgsql"] = meta; } return m_providerMetadataMaps["esPgsql"]; }
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("ProductID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("ProductName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("UnitPrice", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("Discontinued", new esTypeMap("bit", "System.Boolean")); meta.Catalog = "main"; 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["esSQLite"] = meta; } return m_providerMetadataMaps["esSQLite"]; }
private esProviderSpecificMetadata esPgsql(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Id", new esTypeMap("bpchar", "System.String")); meta.AddTypeMap("Notes", new esTypeMap("text", "System.String")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "public"; 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["esPgsql"] = meta; } return m_providerMetadataMaps["esPgsql"]; }
private esProviderSpecificMetadata esAccess(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("CategoryID", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("CategoryName", new esTypeMap("Text", "System.String")); meta.AddTypeMap("Description", new esTypeMap("Memo", "System.String")); meta.AddTypeMap("Picture", new esTypeMap("OLE Object", "System.Byte[]")); meta.Catalog = "Northwind.mdb"; 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["esAccess"] = meta; } return m_providerMetadataMaps["esAccess"]; }
private esProviderSpecificMetadata esPgsql(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Id", new esTypeMap("int8", "System.Int64")); meta.AddTypeMap("TimeType", new esTypeMap("time", "System.DateTime")); meta["AutoKeyText"] = @"nextval('""PgDataTypes_ID_seq""'::regclass)"; meta.Source = "PgDataTypes"; meta.Destination = "PgDataTypes"; meta.spInsert = "proc_PgDataTypesInsert"; meta.spUpdate = "proc_PgDataTypesUpdate"; meta.spDelete = "proc_PgDataTypesDelete"; meta.spLoadAll = "proc_PgDataTypesLoadAll"; meta.spLoadByPrimaryKey = "proc_PgDataTypesLoadByPrimaryKey"; m_providerMetadataMaps["esPgsql"] = meta; } return m_providerMetadataMaps["esPgsql"]; }
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("TerritoryID", new esTypeMap("int8", "System.Int64")); meta.AddTypeMap("Notes", new esTypeMap("varchar", "System.String")); meta.Catalog = "ForeignKeyTest"; meta.Schema = "public"; meta.Source = "TerritoryEx"; meta.Destination = "TerritoryEx"; meta.spInsert = "proc_TerritoryExInsert"; meta.spUpdate = "proc_TerritoryExUpdate"; meta.spDelete = "proc_TerritoryExDelete"; meta.spLoadAll = "proc_TerritoryExLoadAll"; meta.spLoadByPrimaryKey = "proc_TerritoryExLoadByPrimaryKey"; m_providerMetadataMaps["esPgsql"] = meta; } return m_providerMetadataMaps["esPgsql"]; }
private esProviderSpecificMetadata esOracle(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("EmployeeID", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("LastName", new esTypeMap("VARCHAR2", "System.String")); meta.AddTypeMap("FirstName", new esTypeMap("VARCHAR2", "System.String")); meta.AddTypeMap("Supervisor", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("Age", new esTypeMap("NUMBER", "System.Decimal")); meta["AutoKeyText"] = "seq_Employee"; meta.Catalog = "HIERARCHICAL"; meta.Schema = "HIERARCHICAL"; meta.Source = "Employee"; meta.Destination = "Employee"; meta.spInsert = "esEmployeeInsert"; meta.spUpdate = "esEmployeeUpdate"; meta.spDelete = "esEmployeeDelete"; meta.spLoadAll = "esEmployeeLoadAll"; meta.spLoadByPrimaryKey = "esEmployeeLoadByPK"; m_providerMetadataMaps["esOracle"] = meta; } return m_providerMetadataMaps["esOracle"]; }
private esProviderSpecificMetadata esVistaDB4(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("ShipperID", new esTypeMap("Int", "System.Int32")); meta.AddTypeMap("CompanyName", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("Phone", new esTypeMap("NVarChar", "System.String")); meta.Catalog = "Northwind.vdb4"; 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["esVistaDB4"] = meta; } return m_providerMetadataMaps["esVistaDB4"]; }
private esProviderSpecificMetadata esVistaDB4(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.vdb4"; 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["esVistaDB4"] = meta; } return m_providerMetadataMaps["esVistaDB4"]; }
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 esSybase(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("FullName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("DepartmentID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("HireDate", new esTypeMap("timestamp", "System.DateTime")); meta.AddTypeMap("Salary", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("IsActive", new esTypeMap("bit", "System.Boolean")); meta.Catalog = "AggregateDB"; meta.Schema = "DBA"; 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["esSybase"] = meta; } return m_providerMetadataMaps["esSybase"]; }
private esProviderSpecificMetadata esMySQL(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.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["esMySQL"] = meta; } return m_providerMetadataMaps["esMySQL"]; }
private esProviderSpecificMetadata esSqlCe4(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["esSqlCe4"] = meta; } return m_providerMetadataMaps["esSqlCe4"]; }
private esProviderSpecificMetadata esAccess(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("TerritoryID", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("Notes", new esTypeMap("Text", "System.String")); meta.Catalog = "ForeignKeyTest.mdb"; meta.Source = "TerritoryEx"; meta.Destination = "TerritoryEx"; meta.spInsert = "proc_TerritoryExInsert"; meta.spUpdate = "proc_TerritoryExUpdate"; meta.spDelete = "proc_TerritoryExDelete"; meta.spLoadAll = "proc_TerritoryExLoadAll"; meta.spLoadByPrimaryKey = "proc_TerritoryExLoadByPrimaryKey"; m_providerMetadataMaps["esAccess"] = meta; } return m_providerMetadataMaps["esAccess"]; }
private esProviderSpecificMetadata esOracle(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("Id", new esTypeMap("VARCHAR2", "System.String")); meta.AddTypeMap("XmlColumn", new esTypeMap("XMLTYPE", "System.String")); meta.Catalog = "ENTITYSPACES"; meta.Schema = "ENTITYSPACES"; meta.Source = "OracleXmlTest"; meta.Destination = "OracleXmlTest"; meta.spInsert = "esOracleXmlTestInsert"; meta.spUpdate = "esOracleXmlTestUpdate"; meta.spDelete = "esOracleXmlTestDelete"; meta.spLoadAll = "esOracleXmlTestLoadAll"; meta.spLoadByPrimaryKey = "esOracleXmlTestLoadByPK"; m_providerMetadataMaps["esOracle"] = meta; } return m_providerMetadataMaps["esOracle"]; }
private esProviderSpecificMetadata esOracle(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("OrderID", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("ProductID", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("UnitPrice", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("Quantity", new esTypeMap("NUMBER", "System.Decimal")); meta.AddTypeMap("Discount", new esTypeMap("NUMBER", "System.Decimal")); meta.Catalog = "HIERARCHICAL"; meta.Schema = "HIERARCHICAL"; meta.Source = "OrderItem"; meta.Destination = "OrderItem"; meta.spInsert = "esOrderItemInsert"; meta.spUpdate = "esOrderItemUpdate"; meta.spDelete = "esOrderItemDelete"; meta.spLoadAll = "esOrderItemLoadAll"; meta.spLoadByPrimaryKey = "esOrderItemLoadByPK"; m_providerMetadataMaps["esOracle"] = meta; } return m_providerMetadataMaps["esOracle"]; }
private esProviderSpecificMetadata esMySQL(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("DECIMAL", "System.Decimal")); meta.AddTypeMap("Quantity", new esTypeMap("SMALLINT", "System.Int16")); meta.AddTypeMap("Discount", new esTypeMap("DOUBLE", "System.Double")); meta.Catalog = "northwind"; 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["esMySQL"] = meta; } return m_providerMetadataMaps["esMySQL"]; }
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("SupplierID", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("CategoryID", new esTypeMap("Long", "System.Int32")); meta.AddTypeMap("QuantityPerUnit", new esTypeMap("Text", "System.String")); meta.AddTypeMap("UnitPrice", new esTypeMap("Currency", "System.Decimal")); meta.AddTypeMap("UnitsInStock", new esTypeMap("Integer", "System.Int16")); meta.AddTypeMap("UnitsOnOrder", new esTypeMap("Integer", "System.Int16")); meta.AddTypeMap("ReorderLevel", new esTypeMap("Integer", "System.Int16")); meta.AddTypeMap("Discontinued", new esTypeMap("Yes/No", "System.Boolean")); meta.Catalog = "Northwind.mdb"; 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["esAccess"] = meta; } return m_providerMetadataMaps["esAccess"]; }
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 esMySQL(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("TerritoryID", new esTypeMap("INT", "System.Int32")); meta.AddTypeMap("Description", new esTypeMap("VARCHAR", "System.String")); meta.Catalog = "foreignkeytest"; 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["esMySQL"] = meta; } return m_providerMetadataMaps["esMySQL"]; }
private esProviderSpecificMetadata esSybase(string mapName) { if(!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("CustomerID", new esTypeMap("nchar", "System.String")); meta.AddTypeMap("CustomerTypeID", new esTypeMap("nchar", "System.String")); meta.Catalog = "Northwind"; meta.Schema = "DBA"; meta.Source = "CustomerCustomerDemo"; meta.Destination = "CustomerCustomerDemo"; meta.spInsert = "proc_CustomerCustomerDemoInsert"; meta.spUpdate = "proc_CustomerCustomerDemoUpdate"; meta.spDelete = "proc_CustomerCustomerDemoDelete"; meta.spLoadAll = "proc_CustomerCustomerDemoLoadAll"; meta.spLoadByPrimaryKey = "proc_CustomerCustomerDemoLoadByPrimaryKey"; m_providerMetadataMaps["esSybase"] = meta; } return m_providerMetadataMaps["esSybase"]; }
private esProviderSpecificMetadata esMySQL(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("DECIMAL", "System.Decimal")); meta.AddTypeMap("IsActive", new esTypeMap("TINYINT UNSIGNED", "System.Byte")); meta.Catalog = "aggregatedb"; 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["esMySQL"] = meta; } return m_providerMetadataMaps["esMySQL"]; }