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("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("Id", new esTypeMap("NUMBER", "System.Decimal"));
meta.AddTypeMap("Name", new esTypeMap("NVARCHAR2", "System.String"));
meta.AddTypeMap("Parent", new esTypeMap("NUMBER", "System.Decimal"));
meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("NUMBER", "System.Decimal"));
meta.AddTypeMap("DefaultTest", new esTypeMap("TIMESTAMP", "System.DateTime"));
meta.AddTypeMap("ColumnA", new esTypeMap("NUMBER", "System.Decimal"));
meta.AddTypeMap("ColumnB", new esTypeMap("NUMBER", "System.Decimal"));
meta.AddTypeMap("ColumnAB", new esTypeMap("NUMBER", "System.Decimal"));
meta["AutoKeyText"] = "CHILD_SEQ";
meta.Catalog = "ENTITYSPACES";
meta.Schema = "ENTITYSPACES";
meta.Source = "ConcurrencyTestChild";
meta.Destination = "ConcurrencyTestChild";
meta.spInsert = "esConcurrencyTestChildInsert";
meta.spUpdate = "esConcurrencyTestChildUpdate";
meta.spDelete = "esConcurrencyTestChildDelete";
meta.spLoadAll = "esConcurrencyTestChildLoadAll";
meta.spLoadByPrimaryKey = "esConcurrencyTestChildLoadByPK";
m_providerMetadataMaps["esOracle"] = meta;
}
return m_providerMetadataMaps["esOracle"];
}
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 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("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 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 esSQLite(string mapName)
{
if(!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("OrderID", new esTypeMap("integer", "System.Int32"));
meta.AddTypeMap("CustID", new esTypeMap("char", "System.String"));
meta.AddTypeMap("CustSub", new esTypeMap("char", "System.String"));
meta.AddTypeMap("PlacedBy", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("OrderDate", new esTypeMap("datetime", "System.DateTime"));
meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("blob", "System.Byte[]"));
meta.AddTypeMap("EmployeeID", new esTypeMap("integer", "System.Int32"));
meta.Catalog = "main";
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["esSQLite"] = meta;
}
return m_providerMetadataMaps["esSQLite"];
}
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 esSqlCe4(string mapName)
{
if(!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("ProductID", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("SupplierID", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("CategoryID", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("ProductName", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("EnglishName", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("QuantityPerUnit", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("UnitPrice", new esTypeMap("money", "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.sdf";
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["esSqlCe4"] = meta;
}
return m_providerMetadataMaps["esSqlCe4"];
}
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 esSybase(string mapName)
{
if(!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("SupplierID", new esTypeMap("integer", "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("long nvarchar", "System.String"));
meta.Catalog = "Northwind";
meta.Schema = "DBA";
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["esSybase"] = meta;
}
return m_providerMetadataMaps["esSybase"];
}
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 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 esSqlCe(string mapName)
{
if(!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("Id", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("DepartmentID", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("FirstName", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("LastName", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Age", 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.sdf";
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["esSqlCe"] = meta;
}
return m_providerMetadataMaps["esSqlCe"];
}
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 esPgsql(string mapName)
{
if(!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("CustomerID", new esTypeMap("bpchar", "System.String"));
meta.AddTypeMap("CustomerSub", new esTypeMap("bpchar", "System.String"));
meta.AddTypeMap("CustomerName", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("DateAdded", new esTypeMap("timestamp", "System.DateTime"));
meta.AddTypeMap("Active", new esTypeMap("bool", "System.Boolean"));
meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("bytea", "System.Byte[]"));
meta.AddTypeMap("Manager", new esTypeMap("int8", "System.Int64"));
meta.AddTypeMap("StaffAssigned", new esTypeMap("int8", "System.Int64"));
meta.AddTypeMap("UniqueID", new esTypeMap("bpchar", "System.String"));
meta.AddTypeMap("Notes", new esTypeMap("text", "System.String"));
meta.AddTypeMap("CreditLimit", new esTypeMap("numeric", "System.Decimal"));
meta.AddTypeMap("Discount", new esTypeMap("numeric", "System.Decimal"));
meta.Catalog = "ForeignKeyTest";
meta.Schema = "public";
meta.Source = "Customer";
meta.Destination = "Customer";
meta.spInsert = "proc_CustomerInsert";
meta.spUpdate = "proc_CustomerUpdate";
meta.spDelete = "proc_CustomerDelete";
meta.spLoadAll = "proc_CustomerLoadAll";
meta.spLoadByPrimaryKey = "proc_CustomerLoadByPrimaryKey";
m_providerMetadataMaps["esPgsql"] = meta;
}
return m_providerMetadataMaps["esPgsql"];
}
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("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 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 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 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 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 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 esSQLite(string mapName)
{
if(!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("Id", new esTypeMap("integer", "System.Int32"));
meta.AddTypeMap("Name", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("Parent", new esTypeMap("integer", "System.Int32"));
meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("integer", "System.Int32"));
meta.AddTypeMap("DefaultTest", new esTypeMap("datetime", "System.DateTime"));
meta.AddTypeMap("ColumnA", new esTypeMap("integer", "System.Int32"));
meta.AddTypeMap("ColumnB", new esTypeMap("integer", "System.Int32"));
meta.AddTypeMap("ComputedAB", new esTypeMap("integer", "System.Int32"));
meta.Catalog = "main";
meta.Source = "ConcurrencyTestChild";
meta.Destination = "ConcurrencyTestChild";
meta.spInsert = "proc_ConcurrencyTestChildInsert";
meta.spUpdate = "proc_ConcurrencyTestChildUpdate";
meta.spDelete = "proc_ConcurrencyTestChildDelete";
meta.spLoadAll = "proc_ConcurrencyTestChildLoadAll";
meta.spLoadByPrimaryKey = "proc_ConcurrencyTestChildLoadByPrimaryKey";
m_providerMetadataMaps["esSQLite"] = meta;
}
return m_providerMetadataMaps["esSQLite"];
}
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 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 esOracle(string mapName)
{
if(!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("OrderID", new esTypeMap("NUMBER", "System.Decimal"));
meta.AddTypeMap("CustID", new esTypeMap("CHAR", "System.String"));
meta.AddTypeMap("CustSub", new esTypeMap("CHAR", "System.String"));
meta.AddTypeMap("PlacedBy", new esTypeMap("VARCHAR2", "System.String"));
meta.AddTypeMap("OrderDate", new esTypeMap("TIMESTAMP", "System.DateTime"));
meta.AddTypeMap("ConcurrencyCheck", new esTypeMap("NUMBER", "System.Decimal"));
meta.AddTypeMap("EmployeeID", new esTypeMap("NUMBER", "System.Decimal"));
meta["AutoKeyText"] = "seq_Order";
meta.Catalog = "HIERARCHICAL";
meta.Schema = "HIERARCHICAL";
meta.Source = "Order";
meta.Destination = "Order";
meta.spInsert = "esOrderInsert";
meta.spUpdate = "esOrderUpdate";
meta.spDelete = "esOrderDelete";
meta.spLoadAll = "esOrderLoadAll";
meta.spLoadByPrimaryKey = "esOrderLoadByPK";
m_providerMetadataMaps["esOracle"] = meta;
}
return m_providerMetadataMaps["esOracle"];
}
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 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"];
}
/// <summary>
/// This initializes the esDataRequest for the query.
/// </summary>
/// <param name="request">The request to populate.</param>
protected void PopulateRequest(esDataRequest request)
{
IMetadata meta = this.Meta;
esConnection conn = this.es2.Connection;
esProviderSpecificMetadata providerMetadata = meta.GetProviderMetadata(conn.ProviderMetadataKey);
IDynamicQuerySerializableInternal iQuery = this as IDynamicQuerySerializableInternal;
if ((this.queries != null && this.queries.Count > 0) || iQuery.InternalSetOperations != null)
{
AssignProviderMetadata(this, new List <esDynamicQuerySerializable>());
}
string catalog = conn.Catalog;
string schema = conn.Schema;
iData.Catalog = catalog;
iData.Schema = schema;
iData.DataID = meta.DataID;
iData.ProviderMetadata = providerMetadata;
iData.Columns = meta.Columns;
request.ConnectionString = conn.ConnectionString;
request.CommandTimeout = conn.CommandTimeout;
request.QueryType = esQueryType.DynamicQuery;
request.DynamicQuery = this;
request.DataID = meta.DataID;
request.ProviderMetadata = providerMetadata;
request.Catalog = catalog;
request.Schema = schema;
request.Columns = meta.Columns;
if (this.m_selectAll)
{
_selectAll();
}
if (es.QuerySource == null || es.QuerySource.Length == 0)
{
es.QuerySource = providerMetadata.Source;
}
}
/// <summary>
///
/// </summary>
private void AssignProviderMetadata(esDynamicQuerySerializable query, List <esDynamicQuerySerializable> beenThere)
{
if (beenThere.Contains(query))
{
return;
}
beenThere.Add(query);
esDynamicQuery theQuery = query as esDynamicQuery;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
if (theQuery != null)
{
esConnection conn = theQuery.es2.Connection;
if (iQuery.ProviderMetadata == null)
{
esProviderSpecificMetadata providerMetadata = theQuery.Meta.GetProviderMetadata(conn.ProviderMetadataKey);
iQuery.DataID = theQuery.Meta.DataID;
iQuery.Columns = theQuery.Meta.Columns;
iQuery.ProviderMetadata = providerMetadata;
}
iQuery.Catalog = conn.Catalog;
iQuery.Schema = conn.Schema;
}
// This code is for proxies as they are unable to work with column and provider metadata
// until serialized back to the server
if (iQuery.SelectAll)
{
foreach (esColumnMetadata col in (esColumnMetadataCollection)iQuery.Columns)
{
esQueryItem item = new esQueryItem(this, col.Name, col.esType);
query.Select(item);
}
}
else
{
List <esQueryItem> columns = iQuery.SelectAllExcept;
if (columns != null)
{
foreach (esColumnMetadata col in (esColumnMetadataCollection)iQuery.Columns)
{
bool found = false;
for (int i = 0; i < columns.Count; i++)
{
if (col.Name == (string)columns[i])
{
found = true;
break;
}
}
if (found)
{
continue;
}
esExpression item = new esQueryItem(this, col.Name, col.esType);
query.Select(item);
}
}
}
foreach (esDynamicQuerySerializable subQuery in iQuery.queries.Values)
{
AssignProviderMetadata(subQuery, beenThere);
}
if (iQuery.InternalSetOperations != null)
{
foreach (esSetOperation setOperation in iQuery.InternalSetOperations)
{
AssignProviderMetadata(setOperation.Query, beenThere);
}
}
}
