dapper is the micro-ORM for .NET developed and used by the stackoverflow team, focusing on raw performance as the primary aim.
5
votes
2answers
216 views
List<dynamic> to ComboBox
This code get a list<dynamic> from a repository class using Dapper. I need to bind this list to a ...
1
vote
2answers
66 views
Manage connection string
I'm using dapper-dot-net for data access in my ASP.NET MVC application.
So in order to supply a connection string I've came up ...
3
votes
2answers
301 views
Multiple connection string in Web API 2
I have a Web API 2 using Dapper.net, and it's accessed by various client with their own database. Currently, I'm using custom header called Client-Id to identify ...
2
votes
1answer
147 views
Integration tests for a repository with the help of AutoFixture
I find it hard to do integration tests for a repository and very time consuming.
Things I think about when creating integration tests for a repository:
Should I skip them?
Should I create an in ...
1
vote
0answers
245 views
Repository pattern with data access objects
I started a new ASP.NET project in an effort to better learn SQL and Dapper ORM framework.
My idea for data access: Have POCO entities, for each entity have DAO object. When I want to manipulate with ...
2
votes
1answer
608 views
Querying a database with Dapper
In the current project that I am working on, we are using dapper to query the database and sometime when mapping from dynamic types to concrete types we end up with a messy block of code.
I created a ...
4
votes
1answer
1k views
Dapper helper service
I've written a very light wrapper around Dapper to help with unit testing and streamlining the Dapper commands I need.
Execute() is a method created to remove the ...
10
votes
5answers
8k views
Is this Repository Design Pattern Valid and efficient?
I am using Dapper ORM in my Data access Layer, but I think analysis of the code below doesn't depend upon any specific ORM. What should be the single common place throughout the entire Data Access ...
3
votes
1answer
2k views
Using dapper.net and repository pattern in Azure websites
I'm currently on Azure Websites & Azure SQL, some documentation recommends using Async as much as possible as cloud services higher latency and have chances of dropping traffic, but it's also ...
9
votes
1answer
798 views
Compare Oracle Table with SQL Server Table and Update/Insert
Below is the current code which is used to update/insert records from Oracle view to SQL Server table using Dapper. There is not a field to check last record updated date in the oracle view so I have ...