ASP.NET Core Web API + Entity Framework Core : Scaffold-DbContext - EP02

[@CuriousDrive]

Code - github.com/CuriousDrive/BookStores Thanks for watching, please share with your friends :)

[@DaniLearnsIT]

You have the video I have been looking for months! Thank you dude! You are a great teacher :)

[@takecare2689]

You are doing a great job, thank you very very much. I didn't find these tutorials anywhere properly like that.

[@CuriousDrive]

Thanks for the kind words. Please subscribe and share with your friends.

[@CAPS_AMERICA]

Very good tutorial, very well-explained in details! keep making them up please!

[@CuriousDrive]

Thanks for watching Brad. Please share the love!!!

[@Crealnv]

I just learned about asp.net core before I learned about vb.net. I had an error when the connection name in appsettings.json was not the same as in the tutorial, but using the -force command you don't have to bother rebuilding the Entity Framework. Thank you sir

[@MrPramit007]

You're my LifeSaver bro. Keep up the good work.

[@CuriousDrive]

Thanks for watching Pramit. Please share with your friends too :)

[@MrPramit007]

@@CuriousDrive will do 🌟

[@mauriciomontoya702]

Hello, really thank u for these tutorials, it is an amazing work, you explain really good, and very useful things, keep your videos as these please, simple!!

[@CuriousDrive]

Thanks for watching Mairicio and a lovely feedback. Please share with your friends it really helps the channel :)

[@mauriciomontoya702]

@@CuriousDrive It will be a pleasure to share them

[@thedevlife]

This video was very valuable. Thank you.

[@CuriousDrive]

Thanks for watching. I am glad that you are finding them useful

[@beautifulcultures1210]

This exception occur when running -> was not found in the application's configuration. Note that named connection strings are only supported when using 'IConfiguration' and a service provider, such as in a typical ASP.NET Core application

[@CuriousDrive]

Hmmm... weird do you think you can share your code. Maybe I will take look at it

[@beautifulcultures1210]

@@CuriousDrive In appsettings.json "ConnectionStrings": { "BookStoreDb": "Server=COM-LAP-451\\SQLEXPRESS;Database=BookStoreDb;Integrated Security=True" } Package Manager Console PM> Scaffold-DbContext -Connection Name=BookStoreDb Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -force Build started... Build succeeded. When Running System.InvalidOperationException HResult=0x80131509 Message=A named connection string was used, but the name 'BookStoreDb' was not found in the application's configuration. Note that named connection strings are only supported when using 'IConfiguration' and a service provider, such as in a typical ASP.NET Core application. See go.microsoft.com/fwlink/?linkid=850912 for more information. Source=Microsoft.EntityFrameworkCore.Relational StackTrace: at Microsoft.EntityFrameworkCore.Storage.Internal.NamedConnectionStringResolverBase.ResolveConnectionString(String connectionString) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection..ctor(RelationalConnectionDependencies dependencies) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection..ctor(RelationalConnectionDependencies dependencies) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

[@georgezanfir]

@@beautifulcultures1210 I have the same error did you find any method to make it work?

[@CuriousDrive]

@@beautifulcultures1210 To fix this issue you will have to add DBContext in your services. ConfigureServices function in your startup.cs class should look something like this. public void ConfigureServices(IServiceCollection services) { services.AddControllers(); services.AddDbContext(options => options.UseSqlServer(Configuration.GetConnectionString("BookStoresDB"))); } Let me know if you are still facing this issue

[@georgezanfir]

@@CuriousDrive Hi, i just did that but i still get the error that i don't have an Iconfiguration, Solved: Restart Visual studio

[@rigofutty5172]

#CuriousDrive , Need to encrypt the "connection string" stored in appsettings.json? (before published) If yes, How do it? (asp.net 6) . Thank you for your answer!

[@CuriousDrive]

I don't think you should encrypt the connection string but you do not need to store somewhere safe. .NET team suggests to store it in user-secrets. Please check out this section - docs.microsoft.com/en-us/ef/core/managing-schemas/scaffolding?tabs=dotnet-core-cli#configuration-and-user-secrets

[@bhavyar2986]

Im lucky to find this playlist

[@rabahkhiari8621]

who get erreur of sertification SSL you have to Add " ;TrustServerCertificate=true "to the connection string. This will force the client to trust the certificate without validation.

[@kandinagireddy]

Tutorial is very good. Are there any new series on .Net 6/7/8/ Web api??

[@deepanshukumar3943]

Best video.. Thank u so much sir..

[@CuriousDrive]

Thanks for watching Deepanshu. Please share with your friends :)

[@2005bgva]

Thanks for the video. I have a question, what happened if instead of Scaffold into API we have a CLASS LIBRARY and we want to Scaffold into it? how to Scaffold with a connection name? I tried and the error that I had is "A named connection string was used, but the name 'BookStoresDB' was not found in the application's configuration. Note that named connection strings are only supported when using 'IConfiguration' and a service provider" I also added into API Startup.ConfigureServices method this code: "services.AddDbContext(options => options.UseSqlServer(Configuration.GetConnectionString("BookStoresDB")));"

[@CuriousDrive]

You will have to add connection string in the API project too. As the API will make the actual connection not the class library.

[@2005bgva]

@@CuriousDrive The problem persist, I had added a connection string to file "launchSettings.json" but the message is the same "A named connection string was used,......." What I have to do is to follow the comment wrote by @Yakuza 3 months ago, but I would like to understand the reason why with you work and with me do not. these are the steps: into AuthorConstructor: private readonly BookStoresDBContext _context; public AuthorController(BookStoresDBContext context) {_context = context;} return _context.Authors.ToList(); into Startup.cs method "ConfigureServices" string connectionString = Configuration.GetConnectionString("BookStoresDB"); services.AddDbContext(options => options.UseSqlServer(connectionString));

[@Hamdymohamedmohamed]

is there any way to scaffold the stored procedures too?

[@CuriousDrive]

Hello Hamdy, you wiill have to do that manually. Please check out this answer on the StackOveflow stackoverflow.com/a/47353442/12014626

[@ayushtyagi9391]

When I am trying to make dbcontext and model classes under the classs librery models folder using scaffold its succedded but unable to have dbcontext and model classs after using it any help will be appreciated ?

[@CuriousDrive]

Hello Ayush, are there multiple projects in your solution? Please follow below answer from stack overflow. stackoverflow.com/a/58763414/12014626

[@shravansangi6104]

Hi Dear, I have a question in DB First approach.. how to exclude 2 tables out of n tables because those two tables are not going to use in my application and those tables don't have primary key that is throwing an exception. Those tables will be used by SQL jobs in the backend we need to have those tables but don't have to generate models for those tables.. could you please help me? Waiting for your answer.. Thank you.

[@CuriousDrive]

Unfortunately, Scaffold-DbContext does not take -ExcludeTables as one of the arguments. But it does take -Tables, where you will have to mention all the table names for which you want models to be created.

[@shravansangi6104]

Yeah, that is okay but I have to include approximately 120 tables Every time whenever DB has alter statements that is not good practice for everyone. Thank you for your quick response..

[@CuriousDrive]

@@shravansangi6104 I know right. Hopefully in their next release they do something about it. You can post this as an enhancement on EF Core github repo.

[@allanoloo2391]

I am running into a issue that says 'No context type was found in the assembly ' I have searched various developer sites and no solution seems to help me resolve this issue. Can you help?

[@allanoloo2391]

forum.codewithmosh.com/d/532-asp-net-mvc-entity-framework-no-context-type-was-found-in-the-assembly Sites like these provide solutions, but they are not working for me :(

[@CuriousDrive]

When do you get this error? When you run the application or when you run the command?

[@Rise2Fate]

Great tutorial. Is it possible to use postgre instead of SQL

[@capialroja8880]

Hi! Scaffold-DbContext : The term 'Scaffold-DbContext' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. Help Me

[@CuriousDrive]

Hello Capi, sorry that it is not working for you. Are you running this package manager console? I usually get this error when I run into an error in powershell. Please check below articles for running the command in package manager. docs.microsoft.com/en-us/ef/core/cli/powershell docs.microsoft.com/en-us/ef/core/managing-schemas/scaffolding?tabs=dotnet-core-cli

[@TripuranaLohit]

Hi, I tried to Scaffold-DbContext storing connection string and updating in the app setting and also using scaffolding db contect in package manager console to update connection string. I have an issue after I ran the Scaffold-DbContext, it's showing error "Format of the initialization string does not conform to specification starting at index 0" . Please advise me accrdingly

[@CuriousDrive]

Can you please share your appsettings.json file here?

[@DecentProgrammer]

Very Helpful

[@CuriousDrive]

Thanks for the feedback Decent Programmer.

[@awais2127]

Nice Series.

[@CuriousDrive]

Thanks Muhammad, I am gonna be making more videos on querying and saving relational data. So stay tuned!!

[@Program2live]

Issue here: I know you have addressed this in a previous comment but it doesn't work. 'A named connection string was used, but the name 'UserDB' was not found in the application's configuration. appsettings file (I added the following): "ConnectionStrings": { "UserDB": "Server=Localhost;Database=UserDB;Trusted_Connection=True;" } Then I done the command: Scaffold-DbContext -Connection Name=UserDB Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -force Then I cleaned and rebuilt the project. Still the error is 'A named connection string was used, but the name 'UserDB' was not found in the application's configuration. So, then I added (in ConfigureServices(IServiceCollection services) method): services.AddDbContext(options => options.UseSqlServer(Configuration.GetConnectionString("UserDB"))); rebuilt and restarted VS. Still get the error! Any solution to this would be greatly appreciated!

[@CuriousDrive]

CT, did you add below line in ConfigureServices of StartUp.cs? services.AddDbContext(options => options.UseSqlServer(Configuration.GetConnectionString("BookStoresDB")));

[@Program2live]

@@CuriousDrive Hi yeah, i did that and it still didn't work. But fortunetly @Yakuza replied to a comment and the solution for me was to do: string connectionString = Configuration.GetConnectionString("BookStoreDb"); and then services.AddDbContext(options => options.UseSqlServer(Configuration.GetConnectionString(connectionString))); Very strange, and seems like a bug in visual studio or something bizarre, thanks for your videos though they really helped a ton! :D

[@naunihalsidhu]

Did you try using scaffold command with connection name when using seperate class project ?

[@CuriousDrive]

Hello Naunihal, that should work just fine as scaffolding command is a CLI command. It does not matter where you are creating your DBContenxt and your models.

[@naunihalsidhu]

stackoverflow.com/questions/61264033/entity-framework-core-in-asp-net-core-3-1-scaffold-dbcontext-when-using-named-co

[@CuriousDrive]

Are you facing this issue?

[@naunihalsidhu]

yes

[@CuriousDrive]

You using MySQL server but in scaffolding command you are passing SQL server as a provider. That could be the reason why you getting an error

[@manipathak4296]

Can you please provide how to impliment the entity framework with database first approch and stored procedure?

[@CuriousDrive]

That is a really good suggestion. I will let you know when I post a tutorial for it. Thanks again

[@manipathak4296]

Hey sorry my bad, just correcting my statement implementation of stored procedure (CRUD) for legacy application in entity framework core database first approch. I tried to do it with ado. Net and is successful but still we are not able to implement repository pattern and added stuff of core functionality which is bad practice. 😃

[@Marv3Lthe1]

I wonder why such a useful feature is not built into visual studio itself? There should be a UI to point to the database, and select the tables I want to scaffold. Just like they have EDMX file UI in .Net framework.

[@CuriousDrive]

Entity Framework Core still new and EDMX file support will eventually get added in EF Core too. Believe me I am waiting too. :)

[@CLU7CH3R]

@@lukevincent4397 Thanks, that extension completely replaced all of the instructions in this video. There's even an option to pluralize dbsets.

[@talkathiriify]

Lovely Thanks a lot.

[@baktay]

The project did not run after I updated the appsettings.json with connectionstring, and used Scaffold-DbContext -Connection option. I got error: InvalidOperationException: A named connection string was used, but the name 'BookStoresDB' was not found in the application's configuration. Note that named connection strings are only supported when using 'IConfiguration' and a service provider, such as in a typical ASP.NET Core application.

[@CuriousDrive]

I was getting that same error when I used it for the first time. I named the value as "ConnectionString" instead of "ConnectionStrings" in appsettings.json. I would recommend checking that first.

[@baktay]

@@CuriousDrive I have that right actually. On your next vid EP02 you said to add: services.AddDbContext(options => options.UseSqlServer(Configuration.GetConnectionString("BookStoresDB"))); to Startup.cs ConfigureServices, so I did. I still get the error when running localhost:xxxx/author (also "launchUrl": "author", in launchSettings.json Note: My scaffolding worked however PublishersController ("launchUrl": "api/Publishers",)

[@mp-ot7fw]

@@baktay I have not seen why this is happening. However I combined the suggested Startup Services code with the following in the Context OnConfiguring Method. It is working for the time being: if (!optionsBuilder.IsConfigured) { IConfigurationRoot configuration = new ConfigurationBuilder() .SetBasePath(AppDomain.CurrentDomain.BaseDirectory) .AddJsonFile("appsettings.json") .Build(); optionsBuilder.UseSqlServer(configuration.GetConnectionString("MYDB")); }

[@lukagogrichiani8734]

worked thanks

[@GlitchInMatrix]

it may work for you now but good luck retyping it everytime you update database

[@abhishekvaze4758]

I have a postgre sql database at remote location. Can I still scaffold it and use above code to retrieve data from it ?

[@CuriousDrive]

Hello Abhishek, you will have to install a different nuget package the postgre database provider. you can find that here www.nuget.org/packages/Npgsql.EntityFrameworkCore.PostgreSQL

[@rv9570]

Amazing tutorial. Please can you make a vidoe that shows how we can create this manually to connect the database and create models and all. Thansk in advance

[@SatyamSingh-kz5kj]

Sir I need some help regarding my project...how can I contact you...

[@CuriousDrive]

We can talk here Satyam, what's you question?

[@SatyamSingh-kz5kj]

I want what help can l get if I join your channel...?

[@SatyamSingh-kz5kj]

Currently I am working in a IT company their they have kept an assessment on entity framework core and web api which is not relevant to me bcoz I have not studied earlier...so I need your help to clear the assessment...

[@stefanstefanov9860]

And a second thing if you use the tool - Bricelam, be careful because if one of your tables is in plural - my was cases, it changes the class to singular - cas, not case. Its not precise in that, so best practise, name your tables singular

[@CuriousDrive]

Good observation. Thanks for sharing with others :)

[@muhammadusama5251]

When run this "Scaffold-DbContext -Connection Name=dbbook Microsoft.EntityFrameworkCore.SqlServer -OutputDir DbModels" command in class librairy find error like "A named connection string was used, but the name 'NEAProjectdb' was not found in the application's configuration." if any one have idea about this issue kindly help....

[@CuriousDrive]

Hey Muhammad, did you add "dbbook" in your appsettings.json file? Also the connection strings needs to be correct to make it work. Your command seems correct to me.

[@muhammadusama5251]

@@CuriousDrive thanks sir my issue solved

[@reddeimon475]

what to do if my Tables name has $ character?

[@CuriousDrive]

It removes "$" when it scaffolds the database into models

[@reddeimon475]

@@CuriousDrive I mean to scaffold a specific table using -Tables. The command give an error if any of the table name has special characters or space. Like "Table$ Name". A stack overflow suggest to write -Tables "[dbo].[Table$ name]". The scaffolding run without any error but it actually just ignore the table and no models or context made

[@CuriousDrive]

@@reddeimon475 I know what you are talking about. I have encountered this issue too. In that case I would scaffold all the tables and delete the models that I don't need. Also check out EF Core Power Tool extension for Visual Studio. That might make your life easier.

[@Manu-wb2uv]

After adding the pluggin to plurarize the dbsets names I get this error when I scaffold: PM> Scaffold-DbContext -Connection Name=BookStoresDB Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -force Build started... Build failed.

[@Manu-wb2uv]

Oh you need to build the solution and make sure everything is working before you run the command

[@CuriousDrive]

I am glad that you figured it out. Yes you will have to build the project before running the scaffolding command. I ran into the same issue when I was doing this for the first time.

[@namnntt]

No text versions?

[@CuriousDrive]

Nam Nt, I don't completely understand your question. Can you please elaborate?

[@talkathiriify]

Dear Sir Thank you very much for the best and simplest tutorials i ever seen, With Db first approach is there away to update the production DataBase without losing any data on it, because it is alive data? Thanks a lot.

[@CuriousDrive]

When you say update, do you mean to test on it?

[@talkathiriify]

@@CuriousDrive No i mean update the database in a production with the new structure changes. Thank you very much

[@CuriousDrive]

@@talkathiriify In that case, you will either need to know SQL queries to update the structure or you can go with Entity Framework Code first approach. I am going to start a series on code first approach soon.

[@arunkumarsingh8754]

Keep it up

[@CuriousDrive]

Yes. more content coming.

[@stefanstefanov9860]

If you are using Mac my friends, you can dotnet tool install --global dotnet-ef dotnet ef dbcontext scaffold "Server=(localdb)\mssqllocaldb;Database=Blogging;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -o Models And if you need the example with json setting dotnet ef dbcontext scaffold Name=Name_here Microsoft.EntityFrameworkCore.SqlServer -o Models --force

[@CuriousDrive]

Hi Stefan. Thank you so much for your comment. This is will be useful for people using Mac or Linux. We need people like you in our community. Thanks again!!!

[@stefanstefanov9860]

@@CuriousDrive I am building an app based on your videos on blazor and this api. If I find something I will comment. And just a suggestion, can you provide a video for the api not with custom authorization and authentication, but something like identity server ?

[@CuriousDrive]

I am glad that you are building an app while watching the videos. For some of the videos, I am going to fast so if you run into any issues or you have questions, feel free ask questions. I am here to help. Also, please like, comment and share with your friends it really helps.

[@billjustice9476]

I believe this video series is going to help me a lot, but I am having the same connection string issue. After hours of trying everything posted here and researching on the internet, I have returned to hard coding it in the context file, just so I can move forward. If anyone has anything new to try, please post. thanks!

[@CuriousDrive]

Hello Bill, you need to add below line in ConfigureServices method of your StartUp.cs before you scaffold. That should fix the issue. Let me know services.AddDbContext(options => options.UseSqlServer(Configuration.GetConnectionString("BookStoresDB")));

[@billjustice9476]

@@CuriousDrive Thank you. I had tried that and other suggestions in this thread prior to posting, but when I set the context folder back to using the ConnectionString name vs. spelling it out just now, my new controllers (the ones I had scaffolded) worked, but not the one we created early in the tutorial as a copy of the weather controller. When I renamed it and applied scaffolding to the same table, it worked just fine. Thanks again : )

[@atTran-fs3it]

you should have run code before end the video :v

[@CuriousDrive]

I don't think there was a need as we did not change anything in the logic. is it not building for you?

[@nurwantoade5002]

your intonation to flat, i don't understand

[@CuriousDrive]

Yes, I wasn't really good at the audio settings in the earlier videos. I bought new microphone to make that better. It gets better as you progress.

[@DriveU836]

Hey, you made a big Jump from Episode 1 to Episode 2 you lost your audience by not showing Modelling Step by Step with due attention to Navigating Properties and Foreign Keys etc. This is my opinion. You might be right in doing what you seem to be doing but in reality, you left a void. I am not being rude mind this is just healthy criticism to improve from a well-wisher. I was to recommend the best to a coworker for him to get a jump start.

[@CuriousDrive]

Thank you so much for your feedback. Now that I think about it, I should have squeezed an episode explaining navigation properties. You are not being rude. I like your feedback. You should read some other comments on the channel where people think they own me lol. You are fine. Thanks for the feedback again. I will add this episode in my .NET 5 series which I am planning on starting in November.

[@DriveU836]

@@CuriousDrive Your supporting code has models defined?

[@CuriousDrive]

You mean the code on GitHub? Yes I reverse engineered the database and created models

[@akrooma]

damn! i hate API's!

[@CuriousDrive]

Lol why?

[@akrooma]

@@CuriousDrive can't understand the configuration.. so many syntax i type as copy /paste without even understanding it