ASP.NET Core Web API .NET 8 2024 - 3. Entity Framework

[@TheJunioGG]

Great course! I don't know if I did something wrong, but a needed to run this command before the migrations int "dotnet tool install --global dotnet-ef --version 8.0.0"

[@graysongoates7452]

Thank you, internet friend. This helped me so much

[@Suarvae]

An OG indeed

[@metshehu3858]

i love you men

[@jakeaustin2]

What a legend. Thanks for saving us all 😂

[@kaujla8435]

My brother, you're a saint

[@lashondamiller2982]

Hey y'all, if you had an issue with the "dotnet ef migrations add init" part **run this line in the terminal** *dotnet tool install --global dotnet-ef --version 8.0.0* I specifically set it for the version he used in the video, but if you want to use a newer or older version, make sure you change that end part. You should be able to do the migrations add init now 😎

[@TeddySmithDev]

yes, thank you (and the one other person) for posting this. helps people troubleshoot issues.

[@vutungly2004]

thank you

[@АшрафСадыхбеков-й3с]

thank you! save me huge time!)

[@nenygaming11]

thank u🥰

[@jevi08]

thank you so much

[@ScottMeesey]

It is SO encouraging to hear a online tutor like yourself say "PLEASE no errors. PLEASE. Thank you God." :)

[@rawroba]

for anyone that confused on what to pick for server name, once you have already installed sql server, in the pop up window within MSSMS, right beside the Server name: - click on the arrow and a drop down will open up - then select browse for more - then click on database engine and now you should be able to see and select the sql server you previously installed.

[@joaogabrielv.m328]

I'm a simple man: Teddy posts a video, I open youtube app to give a thumbs up and support his channel

[@alreadyghosts7727]

"A sideways database row." Terrific! You have a gift for teaching, not just coding.

[@caseyspaulding]

Program.cs is the back of the TV. Great analogy. 😄

[@SeethMione]

learning with you is exciting and non-boring! thanks a lot.

[@timomartinson]

I have to thank you for all the effort you put into these videos. They are great. Keep em up, bro!

[@TeddySmithDev]

Thanks Timo!!!

[@hype_x6083]

i keep getting this errror when i try running the dotnet ef database update command. "The ConnectionString property has not been initialized"

[@alanthomasgramont]

base is calling the parent constructor with the matching signature. So calling base(dbContextOptions) will look in the parent class (also called the super class) for a consturctor with the signature DBContext(DbContextOptions options) and call that BEFORE it calls any of your constructor body.

[@raulpetcu9202]

make sure to to put semicolon ( ; ) at the end of the connection string

[@stephanieezat-panah7750]

omgosh!!! oh good grief..........

[@Rezishon]

The connection string somehow confused me. There is {PCNAME} part which I changed but I didn't see the \\SQLEXPRESS which also is part of the data source. Please edit it for noob programmers like me who don't read the code completely😂❤

[@kevinm9682]

you should not need the \\SQLEXPRESS

[@wesleymaia9380]

Your comment helped me. Thanks.

[@davincedev]

But what i change to?

[@davincedev]

Nevermind, for someone stuck there just remove the part \\SQLEXPRESS

[@emresalaman759]

@@davincedev you should delete \\SQLEXPRESS if you couldn't find out

[@Suarvae]

This is pretty great ... Thanks for making this series man

[@nenygaming11]

hello brother why my = dotnet ef migrations add init not work pls help me !

[@TheExplodingOtter]

Anyone else get the issue where the comment and stock tables arent created after they run "dotnet ef database update"

[@mertkayaer8964]

I got the same problem and actually can't solve it. When I try to update other migrations to the database, it gives me errors like it already created the tables. And it functions like it created but I can't see them in the Tables folder. I'm confused

[@stephanieezat-panah7750]

most frustrating! I am seeing such: info: Microsoft.EntityFrameworkCore.Migrations[20402] Applying migration '20241219014859_init'. info: Microsoft.EntityFrameworkCore.Database.Command[20101] info: Microsoft.EntityFrameworkCore.Database.Command[20101] Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] info: Microsoft.EntityFrameworkCore.Database.Command[20101] Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241219014859_init', N'8.0.8'); so yes, it LOOKS as if they ARE created, but I am seeing nothing in SQL Server.... .

[@ElliotHoward-f4x]

I keep getting an error when trying to do the dotnet ef update command. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 26 - Error Locating Server/Instance Specified) I have tried multiple different strings for the server name, but ultimately I think it should just be Server->properties->Name. The database name is definitely correct. The database exists in the server, I can see it. I'm not sure what's wrong :/ . Also tried changing SQLEXPRESS to mssqllocaldb as someone suggested it but that didn't work either.

[@TeddySmithDev]

It might be the properties. If you google the error sometimes weird properties like “ssl=true” can cause strange errors. Also might be your password is incorrect. Sometimes wrong password will give instance error.

[@anyta16]

I had the same problem like you and I had to is: in Microsoft SQL Server Management, under your finshark database name(or your DBname), before last option, is SQL Server Agent, right-click on it, start it, and then go back to vs code and try the update command.

[@ElliotHoward-f4x]

@@anyta16 Thanks for the help! I'll give this a go tomorrow :)

[@anyta16]

@@ElliotHoward-f4x and I also change the ConnectionStrings from appsettings.json to "Server={computer name};Database=finshark{or database name};Integrated Security=True;Encrypt=False;TrustServerCertificate=True;" . Hope it will works.

[@ElliotHoward-f4x]

Strangely I had to remove the SQLEXPRESS and it worked, otherwise it was still giving me an error. Not sure if this is going to cause me future problems as I am unsure what this does.

[@Himakevolution]

I could not run the command "dotnet ef migrations add init" although I run "dotnet tool install ..." before. It's always error: Could not execute because the specified command or file was not found. Possible reasons for this include: * You misspelled a built-in dotnet command. * You intended to execute a .NET program, but dotnet-ef does not exist. * You intended to run a global tool, but a dotnet-prefixed executable with this name could not be found on the PATH.

[@ChandlorMartin]

Not sure if anybody else had this issue but when I run "dotnet build" I get an error with "The type or namespace name 'User' could not be found (are you missing a using directive or an assembly reference?)". I am using a class called User instead of Stock but it is otherwise the same so I'm not sure what's up with that

[@EhijeneGideon]

No project was found. Change the current working directory or use the --project option. please am getting this error when i tried creating the migrations please anybody can help me

[@aprodigykid1247]

The question I have is with reading the database data. I do my migrations to my data base smoothly and changed are made when i changed my models. My problem is when trying to execute an entity framework and just getting data from the data already in the DB. It shows that there is no data in the data base when there is.

[@TeddySmithDev]

What Linq query are you using?

[@aprodigykid1247]

_context.Analyses.OrderBy(p => p.AnalyseId).ToList(); @@TeddySmithDev

[@user-zq1um1mf1s]

Make sure to turn off your antivirus if you have one for the dotnet ef migrations add init part of the video. Kept getting a The requested operation cannot be performed on a file with a user-mapped section open error.

[@belkhiriasadok7245]

Sir ,Please, help me i got this error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 26 - Error Locating Server/Instance Specified)

[@belkhiriasadok7245]

i found the solution all you have to do is removing "\\SQLEXPRESS" from the connection string

[@AllenWolff]

Type services on your windows search bar, then search for "SQL Server (SQLEXPRESS)" & the "SQL Server (SQLEXPRESS)", make sure they are in a running status, if not right click and press start.

[@Zara2379M]

Excuse me I can’t find dbcontext in suggestions list what will doing?

[@santkumarvishwakarma5289]

Gr8!, but I had used this command before ef mingration : "dotnet tool install --global dotnet-ef --version 8.0.6"

[@nickylim5204]

Thanks for sharing, this helped me!

[@alejandrosainzmartinez9548]

👏🙌

[@thecap7249]

Was there any speific reason visual studio was not used here ?

[@TeddySmithDev]

The biggest complaint of people learning C# is “VS is too hard to learn” VS Code is way easier for new people and those coming over for python/js

[@tryinfo]

How will install dependency for frontend?

[@brownguyart]

How did he make the database server? I opened sql management studio and Its asking me server name, what should i write in it??

[@rawroba]

right beside the Server name: - click on the arrow and a drop down will open up - then select browse for more - then click on database engine and now you should be able to see and select the sql server you previously installed.

[@ghaithchikhalchabab5676]

In SQL Server Management Studio, what server name should I write? I have just installed it for the first time and am going step by step in this course. Should I understand how SSMS works before taking this course?

[@TeddySmithDev]

You should be able to use the connection string in description. The only thing you will need to learn in SMSS is: 1. Find table you want to look at 2. Right click 3. Select "Select Top 1000" 4. Or if you want to edit, "Edit Data" Those are only commands I used in entire course.

[@kevinpham661]

Hi Teddy, thank you so much for your video. Is there any ways you can create another one to help Mac User? I am getting a lil confused with Azure Data Studio. Thanks

[@mansur.dev1999]

Wow thank Man for this course

[@mischief9499]

My vscode is not showing suggestions and not auto importing too, i have the c# extension and dev kit extension too, i have c# intellisense extension too

[@adrianhernandez5555]

I had the same issue. What I did to fix this issue was uninstalled and reinstalled all of the extensions that this project uses.

[@mischief9499]

@@adrianhernandez5555 hi thx for replying. I fixed this issue 2 weeks ago by simply uninstalling the dev kit extension, everything works fine now

[@hassneltokhy549]

Can I use MySQL instead of SQL Server because I'm struggling to run it on Mac M1.

[@TeddySmithDev]

Yeah sure you can easily swap it out with a few lines of code.

[@ajaysh73]

I have been using VS Code for React for a long time and would love to use for .Net development as well as you are using here but per your experience does it offer same kind of user experience that Visual Studio 2022 gives for .Net development work? I'll appreciate your feedback.

[@TeddySmithDev]

Yeah, I actually prefer it these days because it’s lightweight and works better with React/Angular. The only downside is VS code doesn’t have GUI for database, unit testing is meh, and you have to type commands to run.

[@ajaysh73]

@TeddySmithDev thank you for the feedback, Teddy. I would start using VS code for .Net development going forward. I like it being lightweight.

[@fercho1463]

I can´t install MicrosoftEntityFrameworkCore.SqlServer 8.0.2 using .net 8.0, why? anybody with the same problem?

[@TeddySmithDev]

Does it give error? You may need to install package from pinned comment.

[@fercho1463]

the same problem using visual studio comunity 2022@@TeddySmithDev

[@vasirehman8361]

Bro, just wanna give my side of story to you. In the previous video you have terminal disappeared may be for giving clear pictures of the content but in the these video it came back from start of the video i tried to get the terminal but it ended in failure and after allot of time applied i got to terminal still it when for error. So i was struck at these point. My request is your explanation is good but we are beginner we don’t know much of content of studio code we get confused and get struck overall we remaining same and not able to learn. So, kindly explain all the things please.

[@howlett3527]

i did everything u did, and i had "The ConnectionString property has not been initialized." error when im tryin dotnet ef database update. Did i have problem with sql server management?

[@davitharutyunyan5777]

try to go to the properties of appsettings and set the CopyToOutputDirectory to always

[@vutungly2004]

Hi mr.Smith, hi everyone. I've follow this video but I got stuck when I run the command ' dotnet ef migrations add init ', it printed Build succeed AND the error : "The property 'Stock.Industry' could not be mapped because it is of type 'string', which is not a supported primitive type or a valid entity type. Either explicitly map this property, or ignore it using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'." I certainly write the same syntaxs like you. Can you recommend way to solve the problem ? Thank you so much.

[@TeddySmithDev]

That's very strange error because string should work. Try deleting migrations folder and renaming the migration to different name. Example: "dotnet ef migrations add FirstInit"

[@TeddySmithDev]

could also be that you have private or no set on the Stock -> Industry property

[@memoxcan1]

Actually, I tried many different queries and did a lot of research before asking this question, but I'm sorry I couldn't come to a conclusion. My question is, is there a solution for macOS for the query we use here in DefaultConnection or a related guide?

[@TeddySmithDev]

I updated the description to include Azure Edge connection string. If you have ARM chip you will have to run a different version of MSSQL called "Azure Edge" inside a docker container. Also, instead of SSMS, you use Azure Data Studio (which is honestly better in my opinion). If you have Intel chip, you can use regular MSSQL docker image. Here is blog post that describes down below. community.appsmith.com/tutorial/running-mssql-server-your-mac-m1m2m3-using-docker-bonus-secret-end

[@mc-ty4br]

Here is what eventually worked for me: 1. Google: "Quickstart: Run SQL Server Linux container images with Docker" then follow the steps to run the container 2. Continue the steps 👆 to ssh to the container and create a database 3. "DefaultConnection": "Server=localhost\\mssql-express,1433;Database=;User ID=sa; Password=;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"

[@usmanghause7782]

Well for anyone thinking why we actually have to run this command (dotnet tool install --global dotnet-ef --version 8.*) in the terminal for Migrations to become possible? well the thing is we currently didn't had any Entity Framework Installed for our project so due to lack of the instructions for EF the Terminal just doesn't knows any Commands (dotnet ef migrations add init) to generate Migrations so we RUN this Command dotnet tool install --global dotnet-ef --version 8.* specifying required Version the EF gets installed for our project and Voila now you can finally make migrations possible for creating and managing Databases for your project.

[@Adrian-di2zg]

Why did you say that probably we are not going to work with migrations in a work environment? Of course these are great news for me because it made things easier, but why?

[@TeddySmithDev]

Because as great as migrations are there are so many small processes in SQL that migrations cannot account for or anticipate. One small mistake and the whole entire migrations will be messed up for developers down the line so people end up just making database changes with raw SQL.

[@antoniofuller2331]

The company I work at are current doing a migration so show us how to do it 10:03

[@metshehu3858]

yo if i have a mac can i run a docer image or can i just use. a mysql database ?

[@TeddySmithDev]

For ARM chip, you use “Azure Edge” docker image. For Intel, you use MSSQL docker image. No way to run sql server directly on Mac, but it’s super easy and good to put on your resume as well.

[@metshehu3858]

if you dont mind me asking how do i connect a mysql database insted of this ? i tryed some other tutorails but nothing is working@@TeddySmithDev

[@metshehu3858]

@@TeddySmithDev yo got to ask how can i use the mysql database instes of mssql cuz ime trying to but its giving me a lot of problems

[@PhuongHoHoang-wn5ju]

could you please give me the vs code extensions or settings, sir ? I want my vs code themes look like yours

[@TeddySmithDev]

Night owl + Material UI 👍

[@PhuongHoHoang-wn5ju]

@@TeddySmithDev tysm

[@MrTadsuki]

Can we use Azure Data Studios instead of SSMS or would you recommend we just download SSMS to follow along EDIT: I'm on MAC and it looks like Azure Data Studios is the only option.

[@TeddySmithDev]

Yeah from here on out I’m actually going to start using Azure Data Studios for future courses.

[@metshehu3858]

i love you men

[@ajmaln73]

give me your vscode settings.json theme you use etc

[@AlgoXperience]

2nd and 3rd video are same same i guesss please check and update

[@sandrotabatadze3768]

i had an little issue: i was in incorrect directory so pay attention when adding migrations

[@Khal_Rheg0]

Thank you!

[@Gokuuhanten]

thank you

[@manishsci-figaming]

what the fuck is the course about .net i dont understand

[@АнтонБалашов-м4д]

error: 26 - Error Locating Server/Instance Specified Try to cut \\SQLEXPRESS from the DefaultConnection in appsettings.json

[@shopedevs]

Hey, thanks for this.

[@MrHITStyle]

It worked! Thanks a lot!