public async Task <IActionResult> FeaturesTest1()
{
// Json result.
string jsonResult;
var ewContext = EntityWorksContext.GetEntityWorksContext();
// Use northwind tunnel.
using (var context = new NorthwindContext())
{
// Get all orders.
var orders = await Northwind.Dbo.Orders.GetByAnyAsync();
// Use adventureworks tunnel.
using (var context2 = new AdventureWorksContext())
{
// Get all orders.
var addresses = await AdventureWorks.Person.Address.GetByAnyAsync();
// Get all addresses.
var address = await AdventureWorks.Person.Address.GetByPrimaryKeyAsync(1);
}
}
// Use adventureworks tunnel.
using (var context = new AdventureWorksContext())
{
// Get all orders.
var addresses = await AdventureWorks.Person.Address.GetByAnyAsync();
// Get all addresses.
var address = await AdventureWorks.Person.Address.GetByPrimaryKeyAsync(1);
// Convert data to json.
jsonResult = JsonSerializer.Serialize(addresses, null);
}
// Display json data.
return(Content(jsonResult, "application/json"));
}
/// <summary>
/// Initializes entity works runtime.
/// </summary>
public void InitializeEntityWorks()
{
// Create connection context.
var connectionContext = new ConnectionContext(
"Data Source=DESKTOP-JLE7CPB;Initial Catalog=AdventureWorks;Integrated Security=True",
"Microsoft.Data.SqlClient",
"Microsoft.Data.SqlClient.SqlClientFactory");
// Create connection context dictionary.
var ccDictionary = new Dictionary <string, ConnectionContext>();
ccDictionary.Add("AdventureWorks", connectionContext);
// Create connection mappings dictionary.
var mcDictionary = new Dictionary <string, string>();
mcDictionary.Add("GuestContext", "AdventureWorks");
mcDictionary.Add("UserContext", "AdventureWorks");
mcDictionary.Add("RootContext", "AdventureWorks");
// Set entity works connection context source.
EntityWorksContext.SetConnectionStringSource(ccDictionary);
// Set entity works connection mappings source.
EntityWorksContext.SetContextMappingsSource(mcDictionary);
// Get entity works context instance.
var entityWorksContext = EntityWorksContext.GetEntityWorksContext();
// Initialize entity works context.
entityWorksContext
.RegisterGuestContext()
.RegisterRootContext()
.RegisterUserContext()
.SetLanguageCode("HR")
.SetDebugMode(true);
}