ASP.NET Core Web API .NET 6 2022 - 4. Installing Entity Framework

[@mbulelo-damba]

When I ran the Add-Migration InitialCreate command I got an error. I installed the Microsoft.EntityFrameworkCore and the Microsoft.EntityFrameworkCore.Tools nuggets and everything work. You forgot to install those two. All in all the nuggets I have are : Microsoft.EntityFrameworkCore Microsoft.EntityFrameworkCore.Design Microsoft.EntityFrameworkCore.SqlServer Microsoft.EntityFrameworkCore.Tools Swashbuckle.AspNetCore

[@jeremybrews2521]

Thank you this helped alot

[@glmarc7833]

Thx friend, if u don't add this packages u can't seed the database!!!!!

[@anasofialeitao3989]

this saved me thank you

[@fernandomarcel1996]

gracias amigo!! me ayudaste aquí

[@Console.WriteLine]

THANKS!!!

[@raggardy]

Lol.......I remember watching this a year ago and thinking "WTF, how am I ever gonna learn this?". Now, I've just popped back to recap on fluent api many to manys. You're a star, Teddy and to anyone else thinking "How the f**k am I gonna learn this?", you WILL understand it. Just keep practicing under the guidance of Don Ted ;)

[@ernest1428]

Beginner here, and I am completely lost, lets see how it goes in one year from now haha

[@nikolar5847]

So, how's going?@@ernest1428

[@ronjohnson123]

@@ernest1428 its been 6 months, hows it going?

[@ernest1428]

@@ronjohnson123 I have stopped my studies due to personal reasons, but I finished some courses and reached some SQL queries with .NET, yet I'm planning on continuing next year the journey

[@raiminjshh]

@@ronjohnson123 dude gave up

[@tebogolem5456]

This was super helpful. I was searching for over 2 days and here's everything I wanted

[@phungquanglong1446]

OMG Your tips to the databases (connection string) was so amazing. Love you good works, thank you!

[@witChaos]

this is the best tutorial I've found so far. As another said this is enterprise level and cover a lot of topics. Nice

[@aisyahh38]

Hello Teddy, I really appreciate your effort making these tutorial videos. Your steps really clear and easy to understand. Thank you very much!

[@racmanov]

Pokemon is already plural. SInce (from my long term memory) it actualy stands for Pocket monsters

[@hanchen8106]

For anyone unable to add the SQL server in Visual Studio with an error that says cannot connect or find the SQL server, your connection name may not be the same as the Name in the property window. Instead, click on the "View Connection Properties" in the Server Properties window, and copy the server name instead. Put that in the "Server name" in the connect window in VS

[@saahilsankarb4930]

Thank you, this was so helpful for me. I was facing the same issue and searching for the solution in stackoverflow and all but I couldn't find it. Finally I just went down to the comments and lo and behold! The answer was right there!

[@lucianasuciu4798]

love your videos! they are very good for begginers ! Thank you so much for this ! 🥰😍

[@rotface6969]

For those of you watching who might have trouble hooking up your local server or logging into your local server you have to set "Trust Server Certificate" to "True" when prompted.

[@waynehamberg9248]

Tried running this in .Net 8 but built it using .Net 6. All those warnings you got don't work when you get to a an error in Program line where it's trying to run data. Null exception because all those warnings you have in your classes.

[@dataStream2]

Guys if you have a problem with your Add-Migration and nothing helps, make sure you delete the stuff in your Controllers folder in solution explorer. I forgot to delete the WeatherForecast default app controller and it messed up my build

[@fercho1463]

Un exito mi amigo Teddy, por favor trata de hacer una aplicacion conjunta de Angular y webApi .netCore, una bien avanzada, como tu sabes! gracias amigo por todo el trabajo que nos brindas. Saludos desde Argentina!

[@call_me_cat1709]

I dont know if the course has been updated, but the seed columns doesn't match with de models. Informations such as Rating, FirstName, Last name in Owner and Review does not exist. I checked the UML twice and still, seeds does not match.

[@Ali-vj8hs]

facing same problem

[@Yagoonerz]

He updated it. If you check his Github models file you can see the corrected models. only need to change review and owner models slightly

[@mouhssinsouici9290]

Thank you.. i like this tutorial, actually i'm using as a project for school. just wanna add that there is an easier (for me) way to get the connection string, need just to execute this script >> select 'data source=' + @@servername + ';initial catalog=' + db_name() + case type_desc when 'WINDOWS_LOGIN' then ';trusted_connection=true' else ';user id=' + suser_name() + ';password=' end as ConnectionString from sys.server_principals where name = suser_name()

[@afaqahmed7325]

Thank you for such a cool tutorial. Keep it up🤓👍

[@redlamaravind104]

Although tabels are created when migrating, How the data is injected to database??, do we previously added in db?? can anyone explain me pls

[@stavrostsirlidis3921]

Awsome! thx for this! You are great!

[@dredivany3019]

I know this is code-first approach, but is there a way we can automate these with command line prompt? Im an idiot so I don't understand anything but copy and paste

[@sdscode]

To seed data from the command line: `dotnet run seeddata`

[@daniab2013]

You are perfect! Thank you so much!

[@deepakrevidagar4275]

Teddy I have gone through this entire video series and now I am applying that to another project but I stuck In seed file creation. which you have missed although I have tried several ways to create it and created also and when I am done with it is showing tons of error while running the "dotnet run seeddata" command......... please help me

[@TeddySmithDev]

what are the errors? please post github link and I will look

[@angus1111]

Really really useful! Thanks !

[@MikeKm-hd1ve]

Hey, is there a way to manually execute the sql queries instead of using the dbcontext models?

[@DenisDutu-b1u]

If you use an local server like he does you can only type "." (a dot without the strings) insteat of copying the whole name

[@marypaul9627]

Excellent!new subscriber here

[@maaz6912]

Hello teddy. I am getting the tables but there's no data inside. Every command got executed without any errors. Can you give me a clue as to what might have happened?

[@almoniaruela.8241]

Hello, what is the alternative way if I dont use the Add-Migration? In our task, they say that we need to avoid code first approach with migration.

[@darkoplax7688]

can i do this without downloading microsoft SQL ? like doesnt VS have its built in SQL and I have MySQL on my pc as well ?

[@SS-uf4uq]

i have a proplem, after doing all the steps well, and after updating the database i fount it generate automatically a column with name OwnerId1 in PokemonOwners table, and a column with name CategoryId1 in PokemonCategory table, and i notice that while adding migration the program tell me that it create those 3 columns in the shadow, i don't know the reason, please could you help me with that!

[@Nex7sYv]

Question, is there a way to avoid all this DB creation by sharing a database? it is not easier to share a file of a database?

[@sylgeek1303]

Is onModelcreating method for many to many relationship only?

[@TeddySmithDev]

It's for many things in general, but many to many relationships is one of them

[@adamclarke774]

Ahh i was loving these tutorials until this video, code in db context is still a mystery but also theres additional stuff in the seed data that wasnt in the initial models! There was no Rating in Reviews, or firstname lastname in owner etc :(

[@thetechchronicles]

You could tweak the file acc to your requirements. Maybe use something like this: new PokemonOwner() { Pokemon = new Pokemon() { Name = "Pikachu", BirthDate = new DateTime(1903,1,1), PokemonCategories = new List() { new PokemonCategory { Category = new Category() { Name = "Electric"}} }, Reviews = new List() { new Review { Title="Pikachu",Text = "Pickahu is the best pokemon, because it is electric", Reviewer = new Reviewer(){ FirstName = "Teddy", LastName = "Smith" } }, new Review { Title="Pikachu", Text = "Pickachu is the best a killing rocks", Reviewer = new Reviewer(){ FirstName = "Taylor", LastName = "Jones" } }, new Review { Title="Pikachu",Text = "Pickchu, pickachu, pikachu", Reviewer = new Reviewer(){ FirstName = "Jessica", LastName = "McGregor" } }, } }, Owner = new Owner() { Name = "Jack", Gym = "Brocks Gym", Country = new Country() { Name = "Kanto" } } }

[@VukotaDjLewu95]

Just edit your Reviews and Owner classes. Instead of Name, set FirstName and add one more line for LastName, like this: public string FirstName { get; set; } //Owner.cs public string LastName { get; set; } //Owner.cs and for Review class, just add this: public int Rating { get; set; } //Review.cs After that, you will be able to work without errors! 🙌🏾

[@TrashCanSystem]

@@VukotaDjLewu95 thank you mate, saved me here. teddy smith sometimes leaves things very disconnected, i gave up on his tutorials many times before

[@brianjamesgresos2320]

Are you using SQL Express Core?

[@addybeez3277]

When you create Rating filed ,it's gave me error

[@almoniaruela.8241]

Just add public int Rating { get; set; } in Review class

[@joeyestrada9071]

Man, I'm getting an error on this last step. Does anyone know how to fix it?

[@LukasSoftwareDeveloper]

Maybe you will know the problem. I use AzureSQL and when I try to execute migrate I receive error: The SELECT permission was denied on the object '__EFMigrationsHistory', database 'master', schema 'dbo'. Currently still figuring out how to grant access to master. But still no hope.

[@LukasSoftwareDeveloper]

forgot to include category in defaultconnection heh. (dont use default aka master).

[@TeddySmithDev]

You will prob have to go in and set the permissions in SQL

[@LukasSoftwareDeveloper]

@@TeddySmithDev Thank you for response, anyway, I just used default connection instead what I needed to do was define Catalog. When I defined Catalog= it worked fluently. Thank you for response.

[@opomomlslsa9164]

why we need that seed class plz someone explain how it works? do I need to do the same for my own projects?

[@Mark-nm9sm]

seed class is used to populate dummy data for your project. You dont really need it but if you want to test your API out then this is one way you could create ''random'' test data :)

[@quanhong8967]

sorry i coppy code file Seed.cs but it error with "review"

[@renanwerly3692]

I've created the database and the seed as you shown. When I try to select the rows, the datas that should be there(seed), they're not :(

[@TeddySmithDev]

does it produce error? your database context or settings .cs file is likely culprit

[@renanwerly3692]

@@TeddySmithDev don't worry, I rebuilt everything from zero and it worked! Thank you, you're Awelsome!

[@bolisboktor96]

don't forget to run the seeding commands from the terminal cuz I did and thought they ran automatically when u add migration and update the database

[@Kalliskivi63]

what is this "seed" use for ? i trying create different theme "not pokemon" but im stuck here idk what is that seed

[@TeddySmithDev]

Seed = put fake data into DB so you can have something to work with

[@Kalliskivi63]

@@TeddySmithDev i see, so i can skip that step right?

[@sakkesuominen516]

Are the SQL server and SSMS required? Any tips for mac users?

[@TeddySmithDev]

You can use Azure Data Studio with a docker instance. It works almost exactly the same.

[@ngocanh9250]

Did you change the Model??? The seed was error

[@dariamask-hv9bu]

I have the same. How did you solve the problem?

[@damanm4146]

21:00

[@nazar87ali]

thank for this tutorial but where another videos ??

[@TeddySmithDev]

I put them out one at a time so not to burnout subscribers. Should have one out a day or every other day at least.

[@anionzo]

dotnet run seeddata

[@АрнольдАйзкалнс]

Add migrations errors, update errors, seed errors... nice course :(

[@stoppy4]

Add-Migration succeeded for me, but with some warnings: The foreign key property 'PokemonCategory.CategoryId1' was created in shadow state because a conflicting property with the simple name 'CategoryId' exists in the entity type, but is either not mapped, is already used for another relationship, or is incompatible with the associated primary key type. Same goes with PokemonOwner.OwnerId1 Anyone with the same issue?

[@TeddySmithDev]

Could be many reasons but most common is that EF is not picking up the relationships and is trying to create them on the fly.

[@KrisztianVarga1993]

If for whatever reason connecting to the server doesn't work, Try this: (localdb)\MSSQLLocalDb

[@Kyrathos]

Man, i hate it when people say "just copy paste it" without at least explaining it a little bit. Lets stick to the most important error for this: the seed from the github repo is the FINISHED seed of the project (i assume), which is incompatable with the current status of the project (e.g. reviews suddenly have ratings, owners have first and last names etc). If some1 has trouble with it, either remove incompatabilities from the seed code or add those to the models.

[@zulfikarditya7142]

agreed

[@nareshkumarmm6244]

I agree with that, little bit disappointed as I came for an explanation

[@alimalikashraf7623]

yh really poor tutorial tbh. Hes just writing the code and hardly explaining it.

[@andriitest8015]

thanks

[@damirparipovic5179]

Thank you for this comment. I thought I was going crazy. Updated the models and redid the migration steps. Got it to work :)

[@SnippetSurfer]

Your tutorials are really enterprise level, most other content creators don't do this on this level, they'll just give it from a locally perspective, I bet you get into design patterns too 🔥

[@deepazure]

Dude.. the SQL Server Object Explorer, total diamond right there. Love the tip!

[@ulvinasibli]

It is just a coding session for himself without explaining things, started to become annoying after 4th video..

[@mitulgupta6164]

If facing an error during Add-Migration InitialCreate with build failed then do some changes owner(first name and last name instead of just name ) and review (add ratings)class

[@nareshkumarmm6244]

I get this error -> The property or navigation 'Category' cannot be added to the entity type 'PokemonCategory' because a property or navigation with the same name already exists on entity type 'PokemonCategory'.

[@gio-iova]

thanks a lot,i have not noticed changes in review :)

[@theroostingroaster1584]

When I copied the seed file from your github I was getting red squiglies under rating for reviews and FirstName and LastName, I don't remember you adding them to the models. Or does this have something to do with the relationships. Maybe I messed up there. IF someone had a similar issue would appreciate any help.

[@Nex7sYv]

same here, owner does not have first and last name

[@spencersedano]

If you get an error after doing everything correct, in .csproj file of your project, change the InvariantGlobalization to false

[@Manuel_Roos]

Thank you. It was bugging me

[@Mooseontheloose89]

Decided to load my data directly into the database before starting the application build, SQL is easy and it's so much easier to do this at database level rather than scripting something into the application. But good to see that you've used a different way which will help people who lack SQL skills!

[@kirillzlobin7135]

1:03 Create DB 2:00 Get a connection string 24:11 Finally someone showed me how to find terminal in Visual Studio :)

[@franciscoseverino1851]

it works, I had some issues when running the Add-migration InitialCreate command -- after googling I found that I had the connection string spell wrong, but I made it . I proud of myself. Thanks for watching hahaha- like teddy said

[@TeddySmithDev]

Thanks for watching 😂

[@nettech4939]

This is the best explanation of EF core that I have ever seen. Thank you!

[@trashbin2166]

Teddy, thank you man! You have no idea how helpful I'm finding your content to be!

[@nickben8668]

You don't really have to write all the code in the OnModelCreating-method. EntityFramework is intelligent enough to relate the objects just by the references you are making in the classes. I do get that its nice to know what is happening, but if it's not discribed in more detail, people are most likely just copy-pasting anyway. So for all beginners, you can leave that method empty.

[@NastyManny]

If ur watching this in 2024, you don't have to use modelbuilder anymore because after EntityFramework 5 it map the database only using the model classes

[@daukaevk]

Thank you so much for connection string trick

[@helinkaya8620]

When i run "Update-Database" command I got an error:The ConnectionString property has not been initialized. why is this error caused, how can i fix it.

[@alib1430]

Did you fixed it i have the same error and if you did could you explain me too please

[@interceptionunit6666]

same error

[@codejunkie3531]

if you did it teddy´s way, so make sure you reference the correct key from appsettings.json in your programs.cs. "DefaultConnection" is the key with your ConnectionString, so check options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")) is correct. could be a typo or your autocomplete, messing with you.

[@elchinmirzayev7631]

thank you for like perfect example, because I search what type project can i write, but in the the create seed, I don't understand why you need it? without it isn't good? we can't write different without seed?

[@Console.WriteLine]

I've spent weeks trying to watch how to connect to database... and everywhere i was getting some kind of error. but with you it was so easy!

[@SUMITKUMARKAMTI-t7i]

sucessfully i am able to run my project but data is not get inserted in any table what could be reason for this can anyone please tell me

[@RonGrethel]

O dude that simplifed connecting the sql server thank you for that.

[@tallerdx4020]

Hey you skipped form adding DbContext to Migrations dont get it

[@jamesbuntin-m5x]

i cant find the second Pokemonrevapp foulder it just has the initial one

[@guntza22]

I have issue when I run command dotnet run seeddata then it throw "System.ArgumentOutOfRangeException: startIndex cannot be larger than length of string." I don't know why. I try to repeat to see video and follow the code but not work. I still error when seed data. I can migration and update to database success

[@edrismoavenghafouri]

make sure you add the "builder.Services.AddTransient();"

[@bakhtiarhussain3404]

Data not seeded Idk why

[@yasoobrizvi2706]

same here

[@_vermeulen_musaddiq_]

same here

[@theroostingroaster1584]

hey did you find a fix to why your data didn't seed ?

[@ahmedsamiirr20]

sammmmmme

[@hafidazer1634]

Damn thank you Teddy nice video, but I did use the azure sql database and worked perfectly 🤣

[@TeddySmithDev]

🙌

[@nareshkumarmm6244]

I get this error -> The property or navigation 'Category' cannot be added to the entity type 'PokemonCategory' because a property or navigation with the same name already exists on entity type 'PokemonCategory'.

[@TeddySmithDev]

You may have added the same property to the model

[@HT-go2nb]

How do i do this in VS Code? 2:45

[@jeffqseid2169]

When i run "Update-Database", only the table names (without the data) is being stored at default database named "main". Does it because i didnt follow your database name which i opted to name it as pokemonDB?

[@lightlysal]

No, you can name your database whatever you like. Chances are you missed the step at 3:34 where you type the server name at the top and then *choose from the Database Name field at the bottom.* From the SQL Server Object Explorer you can probably delete your "main" database and then restart from 2:45

[@nebilimbe]

did you add Services.AddTransient(); in program.cs file? i forgot, I encountered the same error.Then I ran the dotnet run seeddata command.

[@Limitlesss06]

hey teddy i have been getting nullrefernceexception everywhere like in models where we set the firstname lastname etc

[@aymansanusi3510]

Bro how did you get that connection string from the search bar?

[@gaikwadpremkumar5830]

Search box.

[@HungTranCR3]

24:24 d

[@Manuel_Roos]

I had my troubles with the Rating in the Seed file, but I managed to put it in the PokemonReview model class. Nice little test you put in there

[@nikhilitty]

If you're using docker for whatever reason, your connection string may have the password show up as a bunch of *****. Just put in your actual password, should work out fine(if you've followed everything else properly that is).

[@cryptoeric24]

Any advice to connect visual studio to sql server running in docker. The sql server object explorer doesn't work and google replies suck

[@SweepAndZone]

So I got everything going good, the only issue I have is that the data is not showing up in the actual local SQL database? I tried to run another Database-Update and it even said No migrations were applied. The database is already up to date. But then I check my database and there isnt anything there?

[@TeddySmithDev]

Make sure you are not checking the “master” db when checking database.

[@thomasmoncrief26]

I had to add "Database = PokemonReview" as a parameter in my connection string, then it got created in the right place. Not sure how I missed copying the right string.

[@sahithshetty1035]

Didn't anyone get errors in the seed file. In the seed file provided in teddy's github link, there are firstname and lastname in the owner. But while creating the owner modal, we didnt include them. Did anyone did something about this?

[@MrChubib0]

Yeah you need to change the Name to FirstName and LastName

[@Michael-wi2ee]

Yeah you need to change it. And update the Review aswell. He integrated a public int Rating

[@Console.WriteLine]

Thanks guys ^

[@dinamohamed13600]

I had no errors but still the database didn't created

[@TeddySmithDev]

You might need to add EF core to program.cs

[@ziadmoghazy6689]

I'm hoping someone sees this but my build fails when i try to Add-migration i tried using -v but that didn't give me any useful info as to why it's failing

[@manuelbacallao1965]

Dude the connection string thing was massive. Love your channel bro. Keep it up.

[@kiran8082]

I am gtting error while adding migration itself, tried hard but couldnt find solution.....

[@wisedragon4883]

I have right columns in database, however there is no data. In the table Countries I have only empty columns Id and Name. How can I fix this?

[@christiancaliendo6875]

I tried making my own database design but I keep getting errors because i cant put Null values into the table

[@TeddySmithDev]

please share error

[@christiancaliendo6875]

Well i solved it by just adding a question mark after variable initializers like int -> int?@@TeddySmithDev

[@itsrino9851]

"you probably didn't need to know that" .... I did, i did need to know that. lol

[@sdscode]

In this specific scenario, what would be the best way to add additional restrictions to fields? for instance, Max Limit of character of the Country, or the Review integer can only be from 1 to 5?

[@umidkurbanov5495]

18:57 how come you have "Migrtations" folder out of nowhere?

[@weston4412]

I use microsoft sql server at my company, I will back up that claim. Good to know it.

[@PrajwalYeotkar]

For me the ServerName was not same as the Name in the Server Properties, It was in View connection properties where its clearly mentioned ServerName might help someone

[@kamilmikua5794]

nice way to get a connection string! But there is simpler way. We can simply connect to server and choose database with connection string from C# level. Anyway Loved your content, Have a nice day good man

[@Cursix]

Teddy i followed ur video and everthing work perfectly but i forgot to add 1model to add 1 more model to the database do i need just update databas? Or add migration again?

[@TeddySmithDev]

Both. Run migration and update database in that order.

[@jorgitorial]

Man! Binge watching (and coding along!) your content. Simply amazing!!!

[@donydp]

Thanks Prof