Using sql server with entity framework core

[@enmanuelr7]

Notice that you are a great teacher. The point that i am trying to make is that i like the way you explain. That's all in this comment, thank you for reading.

[@MrKoukoo]

Hahaha well written!.

[@vinodp7508]

well played...!!

[@yasinyussuf6846]

I don't understand why some dislike a tutorial like this. Please appreciate the effort put on this.He knows what i don't know that is why i am watching this tutorial and i am Not jealous at all :D

[@GabolHackers]

Man, this guy is really great putting such great hardwork online for free.

[@salomonks-francais6752]

Such a great explanation. I easily understood the concept. Thank you.

[@ehaltom1]

Great series so far! Thank you Pragim.

[@rengoku81xx]

A great voice for tutorials and very well explained. Thank you sir!

[@TamilDove]

Superb ❤️ anyone can easily understand ur classes ❤️

[@lifetraveler8008]

I am getting the following error System.ArgumentNullException: 'Value cannot be null. (Parameter 'connectionString')' help please!!

[@devstreamingdev]

same, have you solved it?

[@lifetraveler8008]

@@devstreamingdev I must have , don't remember it though, sorry!!

[@alik.8061]

you are amazing . solved a big problem, thanks a lot.

[@christopherbloomfield1074]

Great explanation. Each lesson is clear i leave with a full understanding of the topic

[@ypwygk652]

THANKS VERY VERY MUCH, PLEASE CONTINUE

[@rsrodas]

Interesting to see multiple calls to Data Base in Index View if we use the model several times (foreach) in the page ?! I'm still not convinced in using Entity Framework...

[@TheITomG]

I don't think you understand how EF works. You can make changes to the model (multiple times) and when your done you save the state to the DB.

[@shravanishetty4916]

Hi...Regarding the above video, when i try to pass the created context class 'AppDbContext' to the 'AddDbContextPool', it gives me a error like 'Static types cannot be used as type arguments'. Could you please help me in resolving this.

[@Csharp-video-tutorialsBlogspot]

Hello Shravani - Not sure why you are getting that error. Can you please share your code.

[@shravanishetty4916]

@@Csharp-video-tutorialsBlogspot : Ya sure. Please find the below code. Startup.cs public class Startup { public Startup(IConfiguration configuration) { Configuration = configuration; } public IConfiguration Configuration { get; } // This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddDbContextPool( options => options.UseSqlServer(Configuration.GetConnectionString("EmployeeDBConnection"))); services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2); } } AppContext.cs public class AppContext : DbContext { public AppContext(DbContextOptions options): base(options) { } public DbSet Employees { get; set; } }

[@shravanishetty4916]

@@Csharp-video-tutorialsBlogspot : Hi Venkat, Got the below issue. There is an 'AppContext' class which derives from 'System' namespace. Hence it got ambiguous between my context class and the one in 'System' namespace. Once I changed the name of my context class then it derived from my project namespace. Now it works fine. Thanks

[@stephen9646]

Is there a way to test the connection of the data source of Sql Server and C#/dotnet core in VS Code? because Visual Studio does and I was wondering if there is one for VS Code.

[@mahekchavan8446]

In this video, correct me if I am wrong, we haven't the _employeeList ,right? In the delete method, we deleted the employee from the list.

[@chandanapatel8505]

Thank you so much for your videos,please upload videos for exporting and importing excel data to table and gridview.

[@pablosalas8586]

how to configure is I need for example: an IDepartmentRepository, etc because in this project we just use one model(Employee), and Department is an enum so, how can i do if i need more models?? anyone knows?

[@Ozzieyy]

omg finally it worked thank you so much!

[@TheUjjwalpandey]

I am enjoying this tutorial. Thanks KudVenkat a lot :)

[@ashutoshporwal]

Hi KudVenkat, appreciate your efforts, I am facing issues while using it in vs 2022, c#6. There is no startup file.

[@johnwindsor5426]

Very nice explaination. Thank you so much give me this great tutorials!!!

[@Csharp-video-tutorialsBlogspot]

Hello John - You are very welcome. I have included all the .NET Course videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/asp-net-core-mvc-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you.

[@naodagere8210]

Thanks for the wonderful demonstration.

[@ljupconewman9357]

Do you know how to scaffold views and sprocedures from SQL Server to our project by using ASP.NET Core 2.2?

[@pavankogpayana]

first thank you so much for your videos, my request is what do you say dapper vs entity framework. I'm waiting for your suggestions/answer

[@Csharp-video-tutorialsBlogspot]

Hello Shiv - From a performance standpoint Dapper is better and from ease of development standpoint EF is better. However, which technology is better for your project depends on several criteria like the mix of technologies you are using, the architecture of the application, the scope of your project, performance, test, deployment and development needs, the development team skills etc.

[@pavankogpayana]

thank you sir, great explanation and teaching....😊

[@Tajdev]

is it the last video of this playlist?

[@Csharp-video-tutorialsBlogspot]

Hello Asif - No this is not the last video. We have a few more important concepts and I will resume those videos soon.

[@halivudestevez2]

I'm interested about Database First, and do everithing I had in normal EF and ASP:NET

[@mikebreeden6071]

I love these videos but just FYI what I simply cannot find is how to get configuration values in a code behind page. I need my AWS Secret Key, etc. Yes, you say how to put them into the "out of project" Secrets location. You explain in detail the order which configuration locations are checked and overridden. No where though can I find how to simply read a configuration setting from a code behind page. .. I do keep watching these though. I learn more even when watching them the second time. Thanks much.

[@virenderkumar-ek5fr]

Great series

[@rahimkhosravinasab1883]

Awesome, this was helpful.

[@mohanaddahe3522]

thank you alot. Please if you can to provide a course to boilerplate framework it's more powerfull framework and depends on design driven development

[@thanks_God_ForEverything]

You are more than hero

[@acollectionofmeaninglesswords]

God bless you

[@sulaimanahmedz5826]

Sir can you make a vide on uploading and downloading images and/or videos in angular 7 and ASP.NET CORE. It would be very helpful.

[@sachingotal11]

When will the next part be uploaded?

[@pallaviganesh5578]

Sir, could you please advise how to connect Sybase database using entity framework in .net core....

[@marselinalatumaerissa1523]

Great job venkat, can you please make parts video starting from insert, delete, update, retrieving data from simple case until using bootstrap and EF? thank you

[@genovme]

Hello, How to connect to existing database, using SQL Server authentication? Best Regards!

[@lianyingzhang1358]

why not subtitles about some videos?

[@lianyingzhang1358]

wow, I fount this Text version of the video link.

[@sakthir3892]

Thank you very much sir

[@pallaviganesh5578]

How to connect Sybase database instead of usesqlserver? Could anyone help?

[@namratakumar764]

Wah

[@eugene-white-shark]

Thank you

[@coolwaterdvr]

Thanks Venkat!

[@sourishdutta9600]

Sir please upload a Node Js tutorial with mongodb please.

[@abidalisidd]

Why too much short videos?

[@salomonks-francais6752]

Because it is better for us beginner to grasps.

[@abidalisidd]

@@salomonks-francais6752 So you are saying that fresher has the only capacity can gran 2 lines of code.

[@salomonks-francais6752]

Would you prefer a short but precise video or a longer one that takes you half of the day for the same content? I have seen some teachers spending hours to dispense the same lessons Mr. Kudvenkat teaches in less than 10 minutes. I personally prefer his technic as once I watch one video, I don't have to revisit it when practising. It's all about time.

[@Sysshad]

its much easier to find the exact info you need by dividing the information. Also he does some repetition of previous content at start so ppl remember better. its a good strategy

[@slashd]

I prefer these short video's instead of those 40+ minutes ones, too many topics discussed so it's difficult to find what you're looking for

[@suchdogemuchwow1231]

a waste of time of a video