Error on trying to generate a MSSQLocalDB Database using EFCore on Rider [Answered]
https://github.com/blueboy90780/EF-Core-6.0-Practice
I'm following the tutorial on https://app.pluralsight.com/library/courses/ef-core-6-fundamentals/table-of-contents - you could download the exercise file from the site. They have a snapshot of the code on the start and end of each learning module, what I'm trying to do is just follow along and do everything they're doing. So my target result is what they are able to do at the end of each module. Right now I'm on module "Building Your First Application using EF Core" but I'm getting an error trying to run the same code she's producing. The specific video I'm referring to is this "Reading and Writing Some Data".
Alternatively, you can just clone my Git Repo above, run the program to see the error message on your respective IDEs.
I'm not sure why I'm getting the error message it's showing and how I can see the database that the code makes. Even if it does run successfully, will that database persist even after the execution of the code ends?
GitHub
GitHub - blueboy90780/EF-Core-6.0-Practice
Contribute to blueboy90780/EF-Core-6.0-Practice development by creating an account on GitHub.
61 Replies
I get this error when trying to run my code. I tried to run the author's code on pluralsight as well but got this error
This is the error I get when trying to connect on Windows 11 :/
GitHub
Cannot connect to (localdb) from .NET Core except via Named Pipe on...
Description I'm trying to connect to SQL Server Express LocalDB from .NET Core 6 on Windows 11 ARM. If I use a connection string that refers to it using the instance name "Data Sou...
It seems like it's an issue with LocalDb on ARM devices.
I fixed it
SQL Server Express LocalDB - SQL Server
Become familiar with SQL Server Express LocalDB. Developers can use this lightweight Database Engine for writing and testing Transact-SQL code.
NVM then 😅
Solution was through there, apparently I needed to install Local DB via the SQL Server 2019 installer
Yeah, if LocalDb wasn't installed it wouldn't work
guess you can close it as solved now 😅
/solveAlso one more question
Is there a equivalent in Rider?
Yes, you can refer to this page for how to set it up
What's the difference between these 2?
I followed this link you provided and the command return one active LocalDB instance
I think this was created with the script from the course
GitHub
PluralsightEFCore6Fundamentals/M02 Building Your FIrst App/After at...
All code samples for EF Core 6 Fundamentals on Pluralsight - PluralsightEFCore6Fundamentals/M02 Building Your FIrst App/After at main · julielerman/PluralsightEFCore6Fundamentals
This is the solution that I am using
I'm not sure I follow, do you expect it to return more than one instance?
No, I might misunderstand. But I think the solution above actually created a new database that persisted after the program ended
This is the output I get when I try to run
Program.cs within PublisherConsole.csproj
Each time I run it, another set of those same repeating output gets added to one another
So like the first time I ran the program, there's only one set, this is the third time I've ran it so now I have 3 sets. I think this is a good indication to me that perhaps there already exists 2 databases and I just created a new one....
My goal is still to do this, to be able to view all database that Program.cs made and see just how many duplicates I have
I don't want to create a new database each time I run the programNo, you have one
MSSQLLocalDBThis solution has 3 projects btw,
Program.cs is located inside the console project
ah..... is this like the LocalDB itself or is this an instance, aka a copy of LocalDB of the LocalDB schema?
Also, why does Program.cs keep producing more sets of the same repeating output everytime I run it?
I just tried running it again for the fourth time and this is what I got
😬
(localdb)\\MSSQLLocalDB is your SQL instance, PubDatabase is the actual database
The app keeps adding the same data everytime it's run to the databaseOOOOOOO
So there's only one database the entire time????
What does it mean by an "instance" in this context then?
I'm not on your machine so I wouldn't know if there exists another database, but for this application, yes it only access a single database.
What even is an instance? Is it instance the same way an object is to a class in C#?
Database Engine Instances (SQL Server) - SQL Server
Find out about Database Engine instances. View information on tasks you can perform on instances, such as configuring properties and enabling protocols.
OOoooh
Interesting... is there a diagram to illustrate this?
Also, if
instance refers to an instance of a Database Engine does this imply that LocalDB is a Database Engine?Illustrate what?
For
LocalDB, yes it's an instance of Database engineDoes "server" refer to my local machine in this case?
Yes
So in this screenshot,
MSSQLLocalDB is an instance of LocalDB which is the database engine right?If I already have one instance that exists, do I need to follow step 1 on https://www.jetbrains.com/help/rider/Connecting_to_SQL_Server_Express_LocalDB.html#step-1-check-and-create-a-localdb-instance ?
JetBrains Rider Help
Microsoft SQL Server LocalDB | JetBrains Rider
You mean creating a development instance in step 2?
Yep I got it to work now
Now that I have maintained a connection, how do I see all those data in the database viewer?
Also why is it that my instance have multiple database even though I created only one?
The other databases are used internally by the db server.
Ah, I see
So the only one that I have made is PubDatabase
How do I delete all the rows in both of my tables?
I've found out where all the data is located
But I want to delete all of them and start over
I'm not really sure because I don't rider's db plugin, but I assume you can select them and click on the red
minus button on the top.
Then saveoh, which one do you usually use to handle database?
Is it
DataGrip, I want to try using other tools if I canI usually use CLI 😅
....
That's next level bro
Anyways, thank you so much for helping out 😄
@Kouhai
✅ This post has been marked as answered!