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 esVistaDB4(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("SupplierID", new esTypeMap("Int", "System.Int32")); meta.AddTypeMap("CompanyName", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("ContactName", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("ContactTitle", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("Address", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("City", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("Region", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("PostalCode", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("Country", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("Phone", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("Fax", new esTypeMap("NVarChar", "System.String")); meta.AddTypeMap("HomePage", new esTypeMap("NText", "System.String")); meta.Catalog = "Northwind.vdb4"; meta.Source = "Suppliers"; meta.Destination = "Suppliers"; meta.spInsert = "proc_SuppliersInsert"; meta.spUpdate = "proc_SuppliersUpdate"; meta.spDelete = "proc_SuppliersDelete"; meta.spLoadAll = "proc_SuppliersLoadAll"; meta.spLoadByPrimaryKey = "proc_SuppliersLoadByPrimaryKey"; m_providerMetadataMaps["esVistaDB4"] = meta; } return(m_providerMetadataMaps["esVistaDB4"]); }
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 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("VersionNumber", new esTypeMap("varchar", "System.String")); meta.Source = "ADefHelpDesk_Version"; meta.Destination = "ADefHelpDesk_Version"; meta.spInsert = "proc_ADefHelpDesk_VersionInsert"; meta.spUpdate = "proc_ADefHelpDesk_VersionUpdate"; meta.spDelete = "proc_ADefHelpDesk_VersionDelete"; meta.spLoadAll = "proc_ADefHelpDesk_VersionLoadAll"; meta.spLoadByPrimaryKey = "proc_ADefHelpDesk_VersionLoadByPrimaryKey"; 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 esSqlCe4(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("OrderID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("CustID", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("CustSub", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("PlacedBy", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("OrderDate", new esTypeMap("datetime", "System.DateTime")); meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("EmployeeID", new esTypeMap("int", "System.Int32")); meta.Catalog = "ForeignKeyTest.sdf"; meta.Source = "Order"; meta.Destination = "Order"; meta.spInsert = "proc_OrderInsert"; meta.spUpdate = "proc_OrderUpdate"; meta.spDelete = "proc_OrderDelete"; meta.spLoadAll = "proc_OrderLoadAll"; meta.spLoadByPrimaryKey = "proc_OrderLoadByPrimaryKey"; m_providerMetadataMaps["esSqlCe4"] = meta; } return(m_providerMetadataMaps["esSqlCe4"]); }
private esProviderSpecificMetadata esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("CategoryID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("PortalID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("ParentCategoryID", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("CategoryName", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("Level", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("RequestorVisible", new esTypeMap("bit", "System.Boolean")); meta.AddTypeMap("Selectable", new esTypeMap("bit", "System.Boolean")); meta.Source = "ADefHelpDesk_Categories"; meta.Destination = "ADefHelpDesk_Categories"; meta.spInsert = "proc_ADefHelpDesk_CategoriesInsert"; meta.spUpdate = "proc_ADefHelpDesk_CategoriesUpdate"; meta.spDelete = "proc_ADefHelpDesk_CategoriesDelete"; meta.spLoadAll = "proc_ADefHelpDesk_CategoriesLoadAll"; meta.spLoadByPrimaryKey = "proc_ADefHelpDesk_CategoriesLoadByPrimaryKey"; 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("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 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 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"]); }
static public string CreateFullName(esDataRequest request, esDynamicQuerySerializable query) { IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal; esProviderSpecificMetadata providerMetadata = iQuery.ProviderMetadata as esProviderSpecificMetadata; string name = String.Empty; string schema = iQuery.Schema ?? request.Schema ?? providerMetadata.Schema; if (schema != null) { name += Delimiters.TableOpen + schema + Delimiters.TableClose + "."; } name += Delimiters.TableOpen; if (query.es.QuerySource != null) { name += query.es.QuerySource; } else { name += providerMetadata.Destination; } name += Delimiters.TableClose; return(name); }
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 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 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 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 esDefault(string mapName) { if (!m_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("AutoKey", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("FirstName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("LastName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("Age", new esTypeMap("int", "System.Int32")); meta.AddTypeMap("DateAdded", new esTypeMap("datetime", "System.DateTime")); meta.AddTypeMap("DateModified", new esTypeMap("datetime", "System.DateTime")); meta.AddTypeMap("AddedBy", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("ModifiedBy", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("EsVersion", new esTypeMap("int", "System.Int32")); meta.Catalog = "AggregateDb"; meta.Schema = "dbo"; meta.Source = "CustomFieldsClient"; meta.Destination = "CustomFieldsClient"; meta.spInsert = "proc_CustomFieldsClientInsert"; meta.spUpdate = "proc_CustomFieldsClientUpdate"; meta.spDelete = "proc_CustomFieldsClientDelete"; meta.spLoadAll = "proc_CustomFieldsClientLoadAll"; meta.spLoadByPrimaryKey = "proc_CustomFieldsClientLoadByPrimaryKey"; 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 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("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 (!_providerMetadataMaps.ContainsKey(mapName)) { esProviderSpecificMetadata meta = new esProviderSpecificMetadata(); meta.AddTypeMap("TransNumber", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("TransDate", new esTypeMap("datetime", "System.DateTime")); meta.AddTypeMap("Descript", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("KaCode", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("KaName", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("GtCode", new esTypeMap("nvarchar", "System.String")); meta.AddTypeMap("DebitAmount", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("CreditAmount", new esTypeMap("numeric", "System.Decimal")); meta.AddTypeMap("IsClosed", new esTypeMap("bit", "System.Boolean")); meta.AddTypeMap("Isverified", new esTypeMap("bit", "System.Boolean")); meta.AddTypeMap("IsActive", new esTypeMap("bit", "System.Boolean")); meta.Source = "transaksiBKU"; meta.Destination = "transaksiBKU"; meta.spInsert = "proc_transaksiBKUInsert"; meta.spUpdate = "proc_transaksiBKUUpdate"; meta.spDelete = "proc_transaksiBKUDelete"; meta.spLoadAll = "proc_transaksiBKULoadAll"; meta.spLoadByPrimaryKey = "proc_transaksiBKULoadByPrimaryKey"; this._providerMetadataMaps["esDefault"] = meta; } return(this._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("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 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("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 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("Id", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("DepartmentID", new esTypeMap("integer", "System.Int32")); meta.AddTypeMap("FirstName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("LastName", new esTypeMap("varchar", "System.String")); meta.AddTypeMap("Age", 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 = "AggregateTest"; meta.Destination = "AggregateTest"; meta.spInsert = "proc_AggregateTestInsert"; meta.spUpdate = "proc_AggregateTestUpdate"; meta.spDelete = "proc_AggregateTestDelete"; meta.spLoadAll = "proc_AggregateTestLoadAll"; meta.spLoadByPrimaryKey = "proc_AggregateTestLoadByPrimaryKey"; 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 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"]); }