✅ Resource to learn how to connect SQL Server to C#
Hello guys, I need to connect C# to SQL Server Management Studio. I was introduced to ADO.Net and the Entity Framework core. But I don't really understand them yet. Is there any recommended resource to learn both of them and goes beyond that, by learning properly how to get started with connected SQL Server Management Studio with C# please (any docs?).
11 Replies
SSMS is software you use to manage SQL Server, it’s not a database.
Did you mean to ask how to connect to SQL Server in C#?
yeah, hmm SSMS is the UI I think to manage the SQL server yeah
I need to connect C# with the database to handle queries
by the way hmm, what do we mean by SSMS is not the database itself pls (sorry this is out of context of the post but just wanted to know so that I use the correct terms later on :c... like when we write a query on SSMS, we get the result of a database, so how SQL server differs from SSMS)
SSMS is to SQL Server like your web browser is to websites.
It’s just a client.
oh ok I see, I will rephrase my post, sorry
$helloef
Getting Started - EF Core
Getting started tutorial for Entity Framework Core
Thanks ! By the way is ADO.Net and EF core related? Like by learning one, we will automatically learn both or we should learn both separately pls
ADO is lower-level than EF.
Both have their uses, but EF does more for you.
yeah I see, I would have to learn both due to uni requirements 🥲 ... do we have a "getting started" section for ADO.Net also in the docs pls
Ask #database
noted, thanks !👍