What are the most important factors to consider while deciding between various ORMs?

Code First Migrations for a custom NuGet package can't be executed from main application

I have created a module to be included in a main MVC3 web application. The module is packaged into a NuGet package and it can be installed and uninstalled via NuGet. Both, the main site and the module use Code First, EF >= 4.3...To create the package I have another MVC3 site and all the functionality is inside an area, so to create the package I ju...

Sharing the Users table between an IdentityDbContext, and a main application DbContext

Why exactly do you want to use two separate ...DbContext...s? It would be easier to have a single context for both ASP.NET identity data and your business entities:...public class DatabaseContext : IdentityDbContext<UserInfo> { public virtual DbSet<Entity> Entities { get; set; } // Your business entities public DatabaseContext() : ...

Entity Framework relationships between different DbContext and different schemas

So, I have two main objects, Member and Guild. One Member can own a Guild and one Guild can have multiple Members....I have the Members class in a separate DbContext and separate class library. I plan to reuse this class library in multiple projects and to help differentiate, I set the database schema to be "acc". I have tested this library exte...

Entity Framework - how to query over multiple tables and choose columns to display

you can do it easly ...Linq query... or ...lambda expressions... over the dbContext classes mapped to the database....check this it would be help you ...Entity Framework Join 3 Tables...How to join multiple tables?

How to choose DbConfigurationType programatically?

I have a ...DbContext...:...[DbConfigurationType(typeof(MySqlEFConfiguration))] public class MyDbContext : DbContext { public DbSet<MyClass> MyClasses { get; set; } } ...Now, what if I want to be able to use another ...DbConfigurationType..., according to AppSettings value?...So that, I change AppSettings value from ...MySQL... to ...MSSQL... a...

LinQ query Simple Where clause and many filter criteria

I need to filter data entity but there is no predefined columns, which I will have to filter....public class EventDocument { public string ID1 { get; set; } public int ID2 { get; set; } public string FirstName { get; set; } public string LastName { get; set; } public string Number { get; set; } public virtual ICollection<Eve...

Run different database types in different environments in dotnet core 2

So I guess I found a nice way for you to do that. You can use the ...ConfigureDevelopmentServices... startup convention to add your SQLSite DbContext. So, just as some basic example you would have:...// Production "like" ConfigureServices public void ConfigureServices(IServiceCollection services) { // Use Sql Server services.AddDbContext<Sc...

Why is my data context class missing from the drop-down when I choose Add Controller?

I had the exact same issue with empty drop downs and resolved it by simply restarting Visual Studio.

What exactly is the difference between ORM and micro ORM?

They are simply different tools. The key goal of micro-ORMs is to ...remove... a lot of layers that an awful lot of data access code ...doesn't need... - basically providing a minimal API surface and trying to balance that by offering the performance benefits that can come from simplicity. For example, things that you would expect to find in an ORM...

Select max as second criteria with Linq

i'm trying to get all rows who has some field = max of that field...to be able to explain my doubt, I will leave an example of model...class model { [Key] [Column(Order=0)] public int Key { get; set; } [Key] [Column(Order=1)] public int Revision { get; set; } public string OtherStuff { get; set; } } ...A data ...