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

ASP.NET Core Web API .NET 8 2024 - 3. Entity Framework
Github: github.com/teddysmithdev/FinS...
SQL Server Connection String Template (WINDOWS):
"Data Source={PCNAME}\\SQLEXPRESS;Initial Catalog={DATABASENAME};Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"
Azure Edge Connection String Template (MAC OS ARM):
"Data Source=localhost;Initial Catalog=finshark;User Id=sa;Password=MyPass@word;Integrated Security=True;TrustServerCertificate=true;Trusted_Connection=false"
Twitter: / teddysmithdev
Github: github.com/teddysmithdev
Linkedin: / teddy-smith-015ba61a3

[@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

[@salmantheyabalmutairi]

thank you man you save the day

[@jakeaustin2]

What a legend. Thanks for saving us all 😂

[@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

[@user-kb9nh5jb3g]

thank you! save me huge time!)

[@nenygaming11]

thank u🥰

[@ScottMeesey]

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

[@Suarvae]

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

[@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.

[@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!!!

[@joaogabrielv.m328]

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

[@caseyspaulding]

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

[@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.

[@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

[@raulpetcu9202]

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

[@Al-mansur1999]

Wow thank Man for this course

[@Khal_Rheg0]

Thank you!

[@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!

[@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.

[@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

[@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?

[@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.

[@tryinfo]

How will install dependency for frontend?

[@nenygaming11]

hello brother why my = dotnet ef migrations add init not work pls 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-uj5jz1rj8p]

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.

[@user-uj5jz1rj8p]

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

[@anyta16]

@@user-uj5jz1rj8p 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.

[@user-uj5jz1rj8p]

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.

[@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.

[@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.

[@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

[@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

[@AlgoXperience]

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

[@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.

[@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

[@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

[@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

[@user-tj3xq4mo2z]

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

[@mijan-karim]

Hey, thanks for this.

[@MrHITStyle]

It worked! Thanks a lot!