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