Best way of using/querying many databases with the same model with EF Core 2.2

c# entity-framework-core rest sql-server visual-studio

Question

I'm currently working on a project and for some strange reason I have to use 32 different SQL Server databases with the same model. These databases have different information but the same exact design.

For some stupid requirement I can't unify these databases. My problem is that I have to implement some Rest services in C# using EF Core 2.2 that perform queries on these databases.

I suspect that if I create a context for each database, the performance of my services is going to be terrible. I'm right? I wonder if there is an efficient / elegant solution for doing this.

1
0
4/11/2020 5:28:14 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

If they all have the same structure (same tables, tables have same properties, etc), then you can have one DbContext but change the connection string on the fly based on which one you are querying. It's easy enough to pass in the connection string to a DbContext, but the exact implementation will depend on what all you're doing.

2
4/11/2020 3:24:57 AM

Related Questions

efcore 2.2 turn off proxy creation for a specific query when Using LazyLoadedProxies

I have an application where in most places I want to be able to use the LazyLoadedProxies so am calling UseLazyLoadingProxies in OnConfiguring....There are specific queries that I don't want proxies as I am going to serialize the object and others where it may be passed to another part of the application and I don't want any N+1 errors so want to e...
c# ef-core-2.2 entity-framework entity-framework-core
asked by runxc1 Bret Ferrier

Using EntityFramework Core 2.2 to seed data that has a database generated key

I'm using EF Core 2.2, using a code first approach. ...I have my entity class:...public class Client { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] [Key] public int ClientID { get; set; } public string Name { get; set; } } ...and I'm seeding my data like so:...var client = new Client { Name = "TestClient"}; modelBuilder.Ent...
ef-core-2.2 entity-framework-core entity-framework-core-migrations
asked by Viqas

Database Schema not changing at Runtime in Asp.net Core 2.2 & Entity Framework Core

i had an application where data is saved in different sql schema for different Users....For e.g. ...User 1 Data is saved in SCHEMA1...User 2 Data is saved in SCHEMA2...Previously application was developed in MVC 3 and it is working fine and as expected. Now we are migrating application in .Net Core 2.2 in which this fucntionality is not working... ...
asp.net asp.net-core asp.net-mvc c# entity-framework-core
asked by Nilesh Gajare

Converting EF Core queries from 2.2 to 3.0 - async await

In EF Core 2.2 I had:... var data = await _ArticleTranslationRepository.DbSet .Include(arttrans => arttrans.Article) .ThenInclude(art => art.Category) .Where(trans => trans.Article != null && trans.Article.Category != null && trans.Article.Category.Id == categoryId.Value) .GroupBy(trans => trans.ArticleId) ...
async-await c# ef-core-3.0 entity-framework entity-framework-core
asked by juFo

I can't load Identity User using EF core 2.2

I'm building a system where I have the ...Order... entity in which each one has a ...Sender.... I'm using...ASP.Net core 2.2 (with Identity for managing the membership);...EF core 2.2....The problem I'm facing is that I can't add the user entity using ....Include(x => x.Sender).... It is always returned as ...null.......This is the ...Order... code...
asp.net-core asp.net-identity c# entity-framework-core
asked by Abdulrhman

Using EF Core 2.2 to decrypt a string using SQL Server DECRYPTBYKEY

Basically I have a POCO model that has a encrypted string. Using EF core 2.2....We use DECRYPTBYKEY to decrypt strings using SYMMETRIC KEY....I am using DBSet.FromSQL to pass in SQL query which calls open symmetric key, get the data including the decrypted value, close symmetric key....FromSQL only allows you to bring back an entity rather than a s...
asp.net-core-2.2 c# entity-framework-core sql-server
asked by Andrew Roberts

EF core 2.2 to EF core 3.1

when I used to use EF 2.2 it rans this code without problems:...var resource = locResRepo.GetWhere(i => i.ForApplication.ToLower() == applicationName.ToLower()) .Where(resourcesConditionExpression) .Select(item => new ResourceKeyObject { Id = item.Id, ResourceKey = item.ResourceKey...
c# ef-core-3.1 entity-framework entity-framework-core
asked by Qhori

Migrate .NET Core 2.2 to .NET Core 3.1 and keep referencing EF Core 2

I have a C# application written with .NETCore 2.2 and Postgres and I would like to migrate it to .NET Core 3.1....The problems is that there are so many breaking changes, especially in Entity Framework that it is not possible to rewrite everything now. At the same time, other developers continue development on .NET Core 2.2 branch and I need to do ...
.net-core .net-core-3.1 c# entity-framework-core
asked by Tomas Kubes

How do I make a raw sql query in EF Core 2.2?

I'm working with a dotnet core 2.x application....We've got a bunch of "code first" entities, and a DBSet for each in the DBContext....EXAMPLE:...public class MyContext : DBContext { public MyContext(DBContextOptions<MyContext> options) : base (options) {} public DbSet<Models.MyTable> MyTable { get; set; } ... ...So far, so good. Now I'd li...
c# entity-framework-core
asked by FoggyDay

Unable to hit oracle stored proc using .Net EF(2.2) Core repository pattern

ORA-00900: invalid SQL statement...This is the error i get when i am trying to hit a stored procedure(in Oracle) from my API....I am using Repository pattern with Entity framework.(EF Core 2.2)...This is my call,...return FetchWithStoredProcedure("PROC_GETMYPROC", new OracleParameter("PARAM1", OracleDbType.Int32, ParameterDirection.Input) { Va...
.net entity-framework-core oracle oracle-sqldeveloper repository-pattern
asked by Shekar.gvr

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow