static async Task Main(String[] args)
{
//PerformanceCacheTest.RunTest(100);
new PLNull(new PLNull_DbFixtureInitDb()).ApplyFilterGroupBy(0).GetAwaiter().GetResult();
//new ProcedureTest().ScalarFunction_get().GetAwaiter().GetResult();
//new PLNull_ManyColumns(new PLNull_ManyColumnsFixtureInitDb()).Filter(1).GetAwaiter().GetResult();
InformationSchemaMapping informationSchemaMapping = GetMappings();
ProviderSpecificSchema providerSchema = CreateSchemaSqlServer(true);
EdmModel dynamicEdmModel;
using (var metadataProvider = providerSchema.CreateMetadataProvider(informationSchemaMapping))
{
DynamicTypeDefinitionManager typeDefinitionManager = DynamicTypeDefinitionManager.Create(metadataProvider);
var dataAdapter = new DynamicDataAdapter(typeDefinitionManager);
dynamicEdmModel = dataAdapter.BuildEdmModel(metadataProvider);
}
String csdlSchema = TestHelper.GetCsdlSchema(dynamicEdmModel);
var parser = new OeParser(new Uri("http://dummy"), dynamicEdmModel);
var stream = new MemoryStream();
await parser.ExecuteGetAsync(new Uri("http://dummy/Orders?$expand=Customer,Items&$orderby=Id"), OeRequestHeaders.JsonDefault, stream, CancellationToken.None);
stream.Position = 0;
String result = new StreamReader(stream).ReadToEnd();
}
private static DynamicTypeDefinitionManager CreateTypeDefinitionManager(bool useRelationalNulls)
{
IEdmModel edmModel = new OeEdmModelBuilder(new OrderDataAdapter(), new OeEdmModelMetadataProvider()).BuildEdmModel();
var metadataProvider = new EdmDynamicMetadataProvider(edmModel);
return(DynamicTypeDefinitionManager.Create(DynamicDbContext.CreateOptions(useRelationalNulls), metadataProvider));
}
static async Task Main()
{
//PerformanceCacheTest.RunTest(100);
await new PLNull(new PLNull_DbFixtureInitDb()).OrderByColumnsMissingInSelect(0);
//new PLNull_ManyColumns(new PLNull_ManyColumnsFixtureInitDb()).Filter(1).GetAwaiter().GetResult();
IEdmModel edmModel = new OeEdmModelBuilder(new OrderDataAdapter(), new OeEdmModelMetadataProvider()).BuildEdmModel();
var metadataProvider = new EdmDynamicMetadataProvider(edmModel);
DbContextOptions options = DynamicDbContext.CreateOptions(true);
var typeDefinitionManager = DynamicTypeDefinitionManager.Create(options, metadataProvider);
////var dbContext = typeDefinitionManager.CreateDynamicDbContext();
////var orders = typeDefinitionManager.GetQueryable(dbContext, "Orders");
////var zzz = orders.Include("Items").Include("AltCustomer").Include("Customer").Include("ShippingAddresses").ToList();
////var orderItems = typeDefinitionManager.GetQueryable(dbContext, "OrderItems");
////var zzz2 = orderItems.Include("Order").ToList();
////dbContext = new DynamicDbContext(options, typeDefinitionManager);
////var zzz3 = new InternalDbSet<DynamicType01>(dbContext).ToList();
var dataAdapter = new DynamicDataAdapter(typeDefinitionManager);
var dynamicEdmModel = dataAdapter.BuildEdmModel();
String schema = TestHelper.GetCsdlSchema(dynamicEdmModel);
var parser = new OeParser(new Uri("http://dummy"), dynamicEdmModel);
var stream = new MemoryStream();
//await parser.ExecuteGetAsync(new Uri("http://dummy/Orders?$expand=Customer,Items&$orderby=Id"), OeRequestHeaders.JsonDefault, stream, CancellationToken.None);
await parser.ExecuteGetAsync(new Uri("http://dummy/Orders"), OeRequestHeaders.JsonDefault, stream, CancellationToken.None);
stream.Position = 0;
String result = new StreamReader(stream).ReadToEnd();
}
private static EdmModel CreateDynamicEdmModel(bool useRelationalNulls)
{
ProviderSpecificSchema providerSchema = DynamicDataContext.Program.CreateSchemaSqlServer(useRelationalNulls);
//ProviderSpecificSchema providerSchema = DynamicDataContext.Program.CreateSchemaPostgreSql(useRelationalNulls);
//ProviderSpecificSchema providerSchema = DynamicDataContext.Program.CreateSchemaMySql(useRelationalNulls);
InformationSchemaSettings informationSchemaSettings = DynamicDataContext.Program.GetSettings();
using (var metadataProvider = providerSchema.CreateMetadataProvider(informationSchemaSettings))
{
var typeDefinitionManager = DynamicTypeDefinitionManager.Create(metadataProvider);
var dataAdapter = new DynamicDataAdapter(typeDefinitionManager);
return(dataAdapter.BuildEdmModel(metadataProvider));
}
}
private static EdmModel CreateDynamicEdmModel(bool useRelationalNulls)
{
//DbContextOptions<DynamicDbContext> options = OrderContextOptions.Create<DynamicDbContext>(useRelationalNulls);
//var informationSchema = new SqlServerSchema(options);
DbContextOptions <DynamicDbContext> options = DynamicDataContext.Program.CreateOptionsPostgreSql(useRelationalNulls);
var informationSchema = new PostgreSqlSchema(options);
InformationSchemaMapping informationSchemaMapping = DynamicDataContext.Program.GetMappings();
using (var metadataProvider = new DynamicMetadataProvider(informationSchema, informationSchemaMapping))
{
var typeDefinitionManager = DynamicTypeDefinitionManager.Create(metadataProvider);
var dataAdapter = new DynamicDataAdapter(typeDefinitionManager);
return(dataAdapter.BuildEdmModel(metadataProvider));
}
}
static async Task Main()
{
//PerformanceCacheTest.RunTest(100);
await new PLNull(new PLNull_DbFixtureInitDb()).ExpandExpandMany(0, false);
//new ProcedureTest().TableFunction_get().GetAwaiter().GetResult();
//new PLNull_ManyColumns(new PLNull_ManyColumnsFixtureInitDb()).Filter(1).GetAwaiter().GetResult();
//IEdmModel edmModel = new OeEdmModelBuilder(new OrderDataAdapter(), new OeEdmModelMetadataProvider()).BuildEdmModel();
//var metadataProvider = new EdmDynamicMetadataProvider(edmModel);
InformationSchemaMapping informationSchemaMapping = GetMappings();
//var informationSchema = new SqlServerSchema(CreateOptionsSqlServer(true));
var informationSchema = new PostgreSqlSchema(CreateOptionsPostgreSql(true));
EdmModel dynamicEdmModel;
using (var metadataProvider = new DynamicMetadataProvider(informationSchema, informationSchemaMapping))
{
DynamicTypeDefinitionManager typeDefinitionManager = DynamicTypeDefinitionManager.Create(metadataProvider);
var dataAdapter = new DynamicDataAdapter(typeDefinitionManager);
dynamicEdmModel = dataAdapter.BuildEdmModel(metadataProvider);
}
String csdlSchema = TestHelper.GetCsdlSchema(dynamicEdmModel);
//var dbContext = typeDefinitionManager.CreateDynamicDbContext();
//var orders = typeDefinitionManager.GetQueryable(dbContext, "Orders");
//var zzz = orders.Include("Items").Include("AltCustomer").Include("Customer").Include("ShippingAddresses").ToList();
//var orderItems = typeDefinitionManager.GetQueryable(dbContext, "OrderItems");
//var zzz2 = orderItems.Include("Order").ToList();
//dbContext = new DynamicDbContext(options, typeDefinitionManager);
//var zzz3 = new InternalDbSet<DynamicType01>(dbContext).ToList();
var parser = new OeParser(new Uri("http://dummy"), dynamicEdmModel);
var stream = new MemoryStream();
//await parser.ExecuteGetAsync(new Uri("http://dummy/Orders?$expand=Customer,Items&$orderby=Id"), OeRequestHeaders.JsonDefault, stream, CancellationToken.None);
await parser.ExecuteGetAsync(new Uri("http://dummy/Orders"), OeRequestHeaders.JsonDefault, stream, CancellationToken.None);
stream.Position = 0;
String result = new StreamReader(stream).ReadToEnd();
}