C#•2y ago

how to connect mysql to .net program as 2nd db

I'm using mongodb in my program and I want to add second db and I decided to MySQL. I created the mysql container but don'tknow how to connect to program.

Pobiega•3/20/24, 8:17 AM

what do you mean by "second database"?

Pobiega•3/20/24, 8:17 AM

what are you going to store in it?

Pobiega•3/20/24, 8:18 AM

would you be running one or the other, or both at the same time?

only you knowOP•3/20/24, 8:18 AM

I'll use both at the same time

Pobiega•3/20/24, 8:18 AM

okay, then make a second DbContext

Pobiega•3/20/24, 8:18 AM

oh right, its you again. you dont use EF for the mongo DB at all right?

Pobiega•3/20/24, 8:19 AM

Repository over EF is considered a huge anti-pattern FYI

PPobiega oh right, its you again. you dont use EF for the mongo DB at all right?

only you knowOP•3/20/24, 8:19 AM

yeah but for mysql I didn't want to write all queries

PPobiega Repository over EF is considered a huge anti-pattern FYI

only you knowOP•3/20/24, 8:19 AM

then what can I do except EF

Pobiega•3/20/24, 8:19 AM

the trick isnt to replace EF

Pobiega•3/20/24, 8:20 AM

its to not use a repository over EF

Pobiega•3/20/24, 8:20 AM

just use the context directly

only you knowOP•3/20/24, 8:20 AM

can I use mysql like i used mongodb?

Pobiega•3/20/24, 8:20 AM

you can, using something like Dapper, or maybe even Linq2Db

Pobiega•3/20/24, 8:21 AM

EF is however the "default" way to integrate with relational DBs in modern C#

only you knowOP•3/20/24, 8:22 AM

but it's against my structure?

Pobiega•3/20/24, 8:23 AM

then change your structure

Pobiega•3/20/24, 8:23 AM

its really simple, just dont use a repository over EF

Pobiega•3/20/24, 8:23 AM

in your service, inject the context itself, and use it directly

Pobiega•3/20/24, 8:24 AM

keep the mongo repositories if you like, thats fine

only you knowOP•3/20/24, 8:24 AM

you know I didn't want to use methods of mongo in my services directly

Pobiega•3/20/24, 8:25 AM

yes

Pobiega•3/20/24, 8:25 AM

so you introduced a repo to abstract mongo away

Pobiega•3/20/24, 8:25 AM

but EF is that abstraction over mysql

Pobiega•3/20/24, 8:25 AM

you could change mysql for postgres, and probably all you'd need to do was re-generate your migrations and DB Snapshot

Mih4n•3/20/24, 8:26 AM

Em if u using ef coore and dependency injection u can just make another db context and then add it to injector

PPobiega so you introduced a repo to abstract mongo away

only you knowOP•3/20/24, 8:27 AM

and also I can use EF for other dbs right? so make sense that i don't need a repo. so no need for making it generic its already

Mih4n•3/20/24, 8:27 AM

Pretty easy

Pobiega•3/20/24, 8:27 AM

yes, EF supports a whole range of relational DBs

Oonly you know and also I can use EF for other dbs right? so make sense that i don't need a rep...

Mih4n•3/20/24, 8:28 AM

If u talking about postgresql and others there are a lot of extensions for them

Mih4n•3/20/24, 8:28 AM

To connect ef core to them

Pobiega•3/20/24, 8:28 AM

MSSQL (SQL Server), Postgres, MySQL, Sqlite, Cosmos, Oracle, even Mongo (but I dont recommend it)

PPobiega MSSQL (SQL Server), Postgres, MySQL, Sqlite, Cosmos, Oracle, even Mongo (but I d...

Mih4n•3/20/24, 8:29 AM

Mongo is non sql)

PPobiega yes, EF supports a whole range of relational DBs

only you knowOP•3/20/24, 8:29 AM

so for services that uses mongo I'll keep repos and for services that uses relational dbs no need for repos

MMih4n Mongo is non sql)

Pobiega•3/20/24, 8:29 AM

Im aware, thats why I dont recommend it.

MMih4n If u talking about postgresql and others there are a lot of extensions for them

only you knowOP•3/20/24, 8:29 AM

yh im planning to use mysql

Oonly you know so for services that uses mongo I'll keep repos and for services that uses relat...

Pobiega•3/20/24, 8:29 AM

specifically with EF Core, yes

Pobiega•3/20/24, 8:29 AM

because EFCore itself already implements the repository pattern

Pobiega•3/20/24, 8:30 AM

a Db Context contains one or more s

Pobiega•3/20/24, 8:30 AM

DbSet is a repository abstraction

Pobiega•3/20/24, 8:30 AM

If you want shared, re-usable queries, like with a normal repository, you can implement that with extension methods on top of for a given T

PPobiega If you want shared, re-usable queries, like with a normal repository, you can im...

only you knowOP•3/20/24, 8:32 AM

I'd like to cuz I don't want to define common crud methods over and over

Pobiega•3/20/24, 8:32 AM

you dont

Pobiega•3/20/24, 8:32 AM

EF already has all the CRUD

Pobiega•3/20/24, 8:33 AM

exists.

only you knowOP•3/20/24, 8:33 AM

so I just define my custom methods

Pobiega•3/20/24, 8:33 AM

same with Remove, etc

Pobiega•3/20/24, 8:33 AM

yes, as extensions

only you knowOP•3/20/24, 8:34 AM

got it but how do I connect it to mysql?

Pobiega•3/20/24, 8:36 AM