asp.net core repositary pattern using ado.net

Question

asp.net core repositary pattern using ado.net

kannan desikan 26

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

Accepted answer

2 additional answers

Your answer

Answer 1

Damiano Andresini 171

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:

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 30,126 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 30,126 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.

Answer 2

Yogi 351

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

Answer 3

Bruce (SqlWork.com) 77,686 Volunteer Moderator

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

Share via

asp.net core repositary pattern using ado.net

2 additional answers

Your answer