Simple C# Data Access with Dapper and SQL - Minimal API Project Part 1

Minimal APIs are now the default in .NET 6. I thought that we should take some time and look at what they are, how they work, and what they might look like in the real world. To that end, we are going to spend two videos covering this topic. This video will cover setting up a SQL database and configuring Dapper for easy data access. We will set up a simple but full CRUD data layer so that when we build our minimal API in part two, we can concentrate on the API itself and not the setup. The great thing is that this lesson will work with almost any user interface, not just a minimal API.

[RobertLenior]

Switched over to Dapper thanks to you Tim! You have been a great help to me. The way you explain things is incredible. Soo much easier than so many others and also your voice helps a lot. No funny accents and very human. Even the tiny errors and correcting them helps.

[manuelgamezz]

Right now, I understand dapper, it's really cool to use to any database, SQL server + stored procedure is magic. Thanks Tim.

[amirhosseinerambue]

OH MY GOD, thank u so much, this is very handy, i think every beginner dev should watch this video, thanks bro

[deltaphilip]

When I want to learn something new, Corey is my go to trainer. To show my appreciation I will purchase one of his classes. I learned working with SQL DB's with EF. I like EF, but it made my SQL programming weak. Learning Dapper my alleviate that handicap.

[cdaddy]

Another great video sir, please keep them coming. For anyone watching wondering wether his courses are worth it, they totally are! I've been a developer for quite some time and I wish I'd found you and your work a long time ago sir. Can't recommend you to other developers enough! Thank you!

[sainsoftsoftwares]

I have been searching .net core web api from the last 2 months and my search end here
It help me a lot, Thanku you very much for this greate informational videos.

[soroushsaghafi]

That was a great video. Thanks for the good content, organized presentation, clear voice and accent. Also the last but not least, thanks for NOT using Entity Framework.

[waynehawkins]

Thanks Tim. Amazing video. It's changing my workflow and now do a mix of EF and Dapper. EF to build my database tables, Visual Studio database project to build my Stored Procedures and Dapper to do all the CRUD. The best of both worlds, or maybe good and evil being nice to each other.

[aythienutties]

Hello Corey your videos ready amazing.. since I've been watching these videos I have broadly understanding in programming

[marmazza]

Hi Tim, can't find the words to describe my thoughts now. Your contents are awesome, that's it, thank you very much!

[hamzaanushath]

This is my 10th hour of watching your explanation. Mind-blowing ❣

[girornsveinsson]

I really like the Contrib extension of Dapper. It allows us to write generic CRUD methods in the case of this video to the SqlDataAccess class and then we don't have to write CRUD stored procedures for every table unless there are some specific side effects that are needed in the sprocs. I think it saves a lot of coding time but of course there might be some reasons such as access control and maybe as you mentioned, performance which would require stored procedures. In my experience though, the Contrib methods are just fine.

[hutchm]

Outstanding work here. This has help me design a clearer roadmap to migrate framework project to core replace linqtosql Orm. Thanks again!

[MrMarkbad]

Wow! Powerful way to setup data access. I am sold.

[crispaul]

Wow... this tool is soooo awesome!!! How did I survive for so long without it!

[haihai]

FINALLY. My most waiting Topic this month. Thanks Tim

[Benexdrake]

I love working with SQL and this Video was Awsome, thank you.

[Mche]

That was such a great help for me, thanks tim! I am really new in c# and worked on a project for my company with ef core but now I am thinking to use dapper instead of ef core because of the advantages you mentioned. I just love this simplicity and the separation of concerns with dapper, also it seems to me much easier to understand than ef core.

[SpiritVector]

Just wanted to say thank you for helping me learn about web development in general. I will soon contribute to this awesome cause!

[delw]

Thanks Tim, looking forward to part two!