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"]);
}
