C# Tutorial - Repository Pattern with C# and Dapper ORM | FoxLearn

We will discuss What is Repository Pattern Benefits of Repository Pattern. An example that uses repository pattern to store and retrieve data from SQL Server database using Dapper ORM in C# .NET Core Windows Forms Application.
Natural Voice Text to Speech: bit.ly/3lvKtpz
Website: foxlearn.com

[@TurntableTV]

Dapper is so underrated as an ORM. So easy to work with databases when you have such a great tool.

[@foxlearn]

Thank you !

[@TurntableTV]

@@foxlearn At this point I think you're just an AI.

[@pablo1beroiza]

good tutorial @Fox Learn!!! Tnx!!!

[@foxlearn]

Thank you !

[@marcioalexandremarcondes557]

Very nice!

[@entemolu1]

I like this channel very much as there is no annoying sound and included only the essence of materials

[@foxlearn]

Thank you so much !

[@thisisnotajoke]

I politely disagree: I find the background music distracting, the strange "click" sound very annoying and the monotone computer voice is not good at keeping my attention focused on the topic (my mind tends to drift while watching this video)

[@anadibrothers-yourwaytorel5259]

One question: Will it work with a later version of the Dapper?

[@Ahmad_Hamdy_Hamdeen]

Thanks 👍👍👍👍👍

[@foxlearn]

You're welcome. Thank you

[@zeeshanahmad1240]

Plz tell me any model of gsm or usb modem. Who supports c# for offline sms

[@coolwaterdvr]

How to bind a combox using repository pattern?

[@creatur]

1.Can you please make a video about for the Processing time with progress bar.....
2. Can you please make a chromium web browser in winform and teach how control it like selenium...
Please🙏 reply

[@foxlearn]

You can view czcams.com/video/p3trglnFZ9Y/video.html and czcams.com/video/ae1_6ELGVYw/video.html

[@raminguliyev1520]

Make some videos for coding bot(whatsapp,instagram,etc) please

[@foxlearn]

Thank you for your suggestion !

[@creatur]

Cam you please make a video of making application config for settings and database and some buttons for disable and enable by that config

[@foxlearn]

You can view this video. czcams.com/video/-KdqdWTNO7Q/video.html

[@nganle2967]

Can you configure dependency injection (DI) for winform, plz make some videos for that

[@foxlearn]

OK. Thank you for your suggestion. I'll upload soon.

[@CezarLisboa1990]

No caso, é melhor ter a camada Business antes da Repository 👍

[@foxlearn]

Thank you !

[@clidton]

How i can implement this in product repisotory and call this function on grid? because i have 1 million products in db and id1 parameter is mention execute all products query from stored procedure
public async Task GetProducts()
{
using (IDbConnection db = new SqlConnection(SqlCon.ConnectionString))
{
if (db.State == ConnectionState.Closed)
db.Open();
var result = await db.QueryAsync("sp_Product", new { id1 = 3 },
commandType: CommandType.StoredProcedure);
return result.ToList();
}
}

[@foxlearn]

var result = await db.QueryAsync("sp_Product", commandType: CommandType.StoredProcedure); for get all

[@clidton]

@@foxlearn thanks for reply but i found the solution and solution is in interface change the implementation like this Task GetAllProducts();

[@SriHariVasamsetti]

How to compatible visual studio 19 .net 5 to .net 4

[@foxlearn]

You can select .NET Or .NET Core

[@SriHariVasamsetti]

@@foxlearn .net

[@jonathangumapac9965]

please help me how to save image in database

[@jonathangumapac9965]

in c# visual studio 2019

[@foxlearn]

You can view this video czcams.com/video/Is7INDgHuX4/video.html . I uploaded

[@Pegie98]

I want to loop my datagrid using that method.

[@foxlearn]

Can you describe more details? Not clear your intention

[@Pegie98]

@@foxlearn I have a sql stored procedure then i want to view in a in the datagrid with selected column then i want to group that in a datagrid. hope you understand my intentions hehehehe thank you.
PG_98

[@5pirithief]

You need to be carful when opening connections to the database. You need to at least wrap that IDbConnection with a using to dispose it once your done with it.
Great video!

[@foxlearn]

It's automatically