Hi, i want to implement ado.net connection to implement crud operations for my project using T class and func., please share any learning link to implement the sam.e

You can use EF Core so you must define the Interface of CRUD operations of repository as image below: Then you can implement the Interface or generic repository with a class:

Repository is a patter which you create in an interface and then you register it on the startup.cs class. Kindly see - ASP.NET Core Razor Pages : CRUD Operations with Repository Pattern and Entity Framework Core

note: as EF implements the repository pattern, it is generally useless to write one on top of it.

asp.net core repositary pattern using ado.net

Accepted answer

Damiano Andresini 171 Reputation points

2022-08-18T10:12:55.943+00:00

You can use EF Core so you must define the Interface of CRUD operations of repository as image below:

Then you can implement the Interface or generic repository with a class:
Please sign in to rate this answer.

1 person found this answer helpful.
kannan desikan 26 Reputation points

2022-08-18T10:45:13.563+00:00

i want to you use ado.net bcs my old project in ado.net framework i want to implement repository parttern using generic for my master entities
please guide us.

AgaveJoe 26,181 Reputation points

2022-08-18T10:51:00.463+00:00

The repository is a pattern. The pattern is the same for ADO.NET or Entity framework. The difference is the implementation.

Anyway, this information is not hidden. Just do a Google search.

https://www.google.com/search?q=ado.net+repository+pattern

kannan desikan 26 Reputation points

2022-08-18T11:20:50+00:00

ipublic interface Ibranch
{
IList<branch> getbranch();
Branch GetBranchId(int? id);
void InsertNew(Branch branch);
void Update(Branch branch);
void Delete(Branch branch);
}

above interface for 1 entites, i have 10 masters each having different model class, can implment same structure or i want to create more inteface for each model.

AgaveJoe 26,181 Reputation points

2022-08-18T11:30:31.74+00:00

Your example code indicates that you are not implementing the repository design pattern because the interface is specific to Branch. The interface should be generic.

public interface IRepository<T> { IList<T> GetAll(); T Find(int? id); void Insert(T item); void Update(T item); void Delete(T item); }

The repository design pattern has been around a very long time and the internet is full of example code. Please make an effort to learn the repository design pattern. If you have a problem understanding the C# syntax then ask a specific question.

I think it is important to mention that the repository pattern is not a magic bullet. Usually a better pattern is creating services that solve business rules because business logic typically involves more than one table.
Sign in to comment

asp.net core repositary pattern using ado.net

2 additional answers