Dapper Tutorial - Knowledge Base (KB)

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...

Where to put my queries - model vs. controller

I ...just switched from ActiveRecord/NHibernate to Dapper.... Previously, I had all of my queries in my controllers. However, some properties which were convenient to implement on my models (such as summaries/sums/totals/averages), I could calculate by i...

What's the best architecture for a medium-sized, high traffic web site?

I'm starting a new project (non-corporative) and I want to know how would be a great architecture nowadays....What I'm planning for now is to use: ...ASP.NET MVC 4.0...SQL Server 2008 or 2012...EF 5.0 under .NET 4.5, with Dapper...Implementation of Reposi...

Transactions in "dapper-dot-net"

How do I create a transaction if my DAL is using dapper-dot-net?...My c# winform application will be used in network and the data will be saved to a central sql server....My use case requires use of transactions. Can I do this using dapper, or will I need...

Passing DTO to my ViewModels constructor to map properties

In my solution I have two projects....Project 1 (Core) Mapping SQL to DTO using Dapper...Project 2 (WebUI - ASP.NET MVC 4) Here I use a ViewModel per View....Examples of a Controller... [HttpGet] public ActionResult Edit(int id) { // Get ...

Using multiple database schema in a multi tenant application

I am moving my current application to a multi tenant architecture. With a single code base, i need to address multiple tenants. I am using single database, multiple schema approach. Each tenant will be assigned a separate schema with the meta data saved i...

C# How to read ,validate multi tab excel sheet data and import in sql server tables

I need to upload ecommerce catalog data by reading data from multiple tabs And insert those data in SQL server tables....Whats best way to implement the same using c# and dapper .net and SQL server....Thanks Rakesh

DDD principles and repositories with Dapper

I'm setting up a solution in which I apply onion architecture and DDD patterns....One of the DDD principles encourages domain entities to have only private setters and a private default constructor, to make sure you cannot create domain entities in an inv...