Skip to content

Instantly share code, notes, and snippets.

@dcomartin
Last active November 10, 2017 01:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dcomartin/a254a8de5ffc7463b67fd4d0e7b51432 to your computer and use it in GitHub Desktop.
Save dcomartin/a254a8de5ffc7463b67fd4d0e7b51432 to your computer and use it in GitHub Desktop.
class Program
{
static void Main(string[] args)
{
var tenant1 = Guid.NewGuid();
var tenant2 = Guid.NewGuid();
int customerId = 1;
Seed(tenant1, customerId, "Derek Comartin");
Seed(tenant2, customerId, "CodeOpinion.com");
using (var db = DbFactory(tenant1))
{
var customer = db.Customers.Single(x => x.CustomerId == customerId);
Console.WriteLine($"Hello {customer.Name}");
}
using (var db = DbFactory(tenant2))
{
var customer = db.Customers.Single(x => x.CustomerId == customerId);
Console.WriteLine($"Hello {customer.Name}");
}
Console.ReadKey();
}
private static MyDbContext DbFactory(Guid tenantId)
{
var connection = @"Server=(localdb)\mssqllocaldb;Database=EFCoreMultiTenant;Trusted_Connection=True;";
return new MyDbContext(tenantId, connection);
}
static void Seed(Guid tenantId, int customerId, string name)
{
using (var db = DbFactory(tenantId))
{
db.Customers.Add(new Customer
{
CustomerId = customerId,
TenantId = tenantId,
Name = name
});
db.SaveChanges();
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment