db-schema – Tarik Billa

DB Schema For Chats?

September 12, 2023 by Tarik

Here’s a start using MySQL Workbench and the create script SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’TRADITIONAL’; CREATE SCHEMA IF NOT EXISTS `chats` DEFAULT CHARACTER SET utf8 COLLATE default collation ; — —————————————————– — Table `chats`.`chat` — —————————————————– CREATE TABLE IF NOT EXISTS `chats`.`chat` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , PRIMARY … Read more

Using Entity Framework 6 with Multiple DB Schemas but using One DBContext

April 27, 2023 by Tarik

You can map each table to its own schema by fluent mapping only. In your DbContext subtype you should override OnModelCreating (if you haven’t done so already) and add statements like this: modelBuilder.Entity<Department>() .ToTable(“t_Department”, “school”); Entities that you don’t map like this explicitly will be placed in the default dbo schema, or you can provide … Read more