Entity Framework Core - Knowledge Base (KB)

Setting schema name for DbContext

I know how to set the schema for a table in my context but is there a way to set the default schema for all the tables in a context? i.e. ...[Schema = "Ordering"] public class MyContext:DbContext { public MyContext() : base("name=ConnectionSt...

Dynamically changing schema in Entity Framework Core

UPD...here... is the way I solved the problem. Although it's likely to be not the best one, it worked for me....I have an issue with working with EF Core. I want to separate data for different companies in my project's database via schema-mechanism. My qu...

Add constraint to existing SQLite table

I'm using SQLite, which ...doesn't support... adding ...a constraint... to an existing table....So I can't do something like this (just as an example):...ALTER TABLE [Customer] ADD CONSTRAINT specify_either_phone_or_email CHECK (([Phone] IS NOT NULL) OR (...

Using a single Entity Framework Core DbContext to manage multiple database schemas with homonymous tables

In a ....NET Core 2.1 library... I need to access to a ...MySQL... database organized in multiple schemas with ...tables that can have the same name across those schemas.... I can't make any changes to the DB since it comes from another company. For most ...