zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
  •   Download  

Dapper Tutorial - Knowledge Base (KB)

14 results for: in tag: repository-pattern

Repository Pattern Where and Lightweight ORMs

For my IRepository, i would like:...To have it be usable by a micro-orm like dapper, petapoco, massive etc... for the SPEED...To have where clauses that get run on the server, hopefully using Expression/IQueryable style (which is also very swappable)...Is...
architecture dapper massive petapoco repository-pattern
asked by Micah

Procedure or function expects parameter which was not supplied

My stored procedure is ...Create proc [dbo].[InsertPerson] ( @LastName VARCHAR(64), @FirstName VARCHAR(64), @Age INT ) AS INSERT INTO Person Values(@LastName,@FirstName,@Age) ...The save method of the BaseRepository class is as follo...
asp.net-mvc-4 dapper repository-pattern stored-procedures unit-of-work
asked by Mojammel Haque

How to implement Unit Of Work pattern with Dapper?

Currently, I am trying to use Dapper ORM with Unit Of Work + Repository Pattern....I want to use Unit of Work as opposed to a simple dapper Repository due to the fact that my insert and updates require a degree of transaction processing. I have been unabl...
dapper repository-pattern unit-of-work
asked by Stig

Connection design issue in Dapper, UoW, Generic Repository and multiple databases

I'm trying to build a repository layer for an application which interacts with 3 databases, all MSSQL. I made the repository structure is based on ...Dapper and Unit Of Work Pattern... and looks like below: ...Is this a good design? or what could be a bet...
c# dapper multiple-databases repository-pattern unit-of-work
asked by Kay

How can I return data in this specific way

I am building an angularjs app with a c# backend with dapper micro orm which gets me data from the database. ...I wanted the data returned to look like this: ...[{ "CategoryId": 1, "CategoryName": "cat1", "Items": [{ "I...
c# dapper json repository-pattern
asked by aliaz

Support both MS-SQL and Oracle

I have developed an enterprise product which is currently live in a few sites. This was developed on the MS stack using SQL server as back-end data storage. I have not used EF/NHibernate for data-access, instead used dapper and some custom extensions arou...
c# dapper entity-framework repository-pattern sql-server
asked by Sharath Chandra

Repository Design Pattern with Dapper

This is maybe more a question for code review rather than stack overflow....I am using Dapper for a MicroORM to retrieve and Save Data to SQL Server 2014. I have got DTO classes in a DTO Proj that represent the Data retrieved from the DB or saved to the ...
.net c# dapper design-patterns repository-pattern
asked by Ctrl_Alt_Defeat

Difference between a 'using statement' for every SqlConnection and single SqlConnection as private property in C# data layer

When implementing the repository pattern using Dapper ORM I am currently doing the following:...private readonly ConnectionStrings _connectionStrings; private IDbConnection _db; public CustomerRepository(IOptions<ConnectionStrings> connectionStrings) { ...
c# dapper n-tier-architecture repository-pattern sqlconnection
asked by Blake Rivell

Dapper with UOW - Don't close connections

I have implemented my DAL with Dapper by using following artical...Dapper Implementation...But It is created a connection with db each and every database call. It does not reuse connection pool. I believe i have closed and disposed the connection properly...
dapper repository-pattern unit-of-work
asked by Denuka

Designing Model with foreign key

I am building an ORM by using Unit or Work and Repository using Dapper. I have searched the internet on this problem and no luck....I have the following tables:...As you can see, Instance has Entity inside. I have 2 approaches:...Approach 1:...public clas...
dapper repository-pattern unit-of-work
asked by Red Wei

Generic Repository pattern for .net core with Dapper

I followed a tutorial on Generic Repository Pattern with ASP.NET core with EF CORE, ...here... for example ... public class Repository<T> : IRepository<T> where T : class { protected readonly DbContext _dbContext; protected readonly DbSet<T...
asp.net-core c# dapper generic-programming repository-pattern
asked by Lakshan

C# Repository Pattern for each DB entities or by module

I have a ...c#...WebApi... project that uses ...Dapper... with ...Repository Pattern... for data layer....In other projects I have created a Repository by module of by business logic. So instead of having a Repository for each entity I create one Reposito...
c# dapper repository-pattern
asked by VAAA

When using Dapper, is there a point in making repositories Transient?

If we're using ...EntityFramework... I can see why every repository should be injected in a transient lifetime, but what if we're using ...Dapper...?...Is there any problem at all?
asp.net-core c# dapper dependency-injection repository-pattern
asked by SpiritBob

CRUD operation in asp.net core MVC using kendo grid and stored procedures and dapper with the Repository pattern

I am trying to do CRUD operation in asp.net core MVC, When I try to insert data into the grid(Create Function), VS turns me with an error that can not nut be null! I think the problem is UI does not send my inputs to the SQL or other things that I don't k...
asp.net-core dapper kendo-grid repository-pattern stored-procedures
asked by Ashkan Pirmani

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...