Dapper Tutorial - Knowledge Base (KB)

Does Dapper support SQL 2008 Table-Valued Parameters 2?

I know that dapper can support TVF, but how do you send extra parameters along with TVF (without adding it to the IntDynamicParam class)? See the below example from Tests.cs, i have modified to add the extra parameter:...connection.Execute("CREATE TYPE in...

Convert IEnumerable<object> frow WCF to another local IEnumerable<object> is that possible?

I have this function in a WCF service:...public IEnumerable<Product> ListProducts() { return dal.RunDapper<Product>("listarProdutos"); } ...It will execute a proc with Dapper and map data with this class:...[DataContract] public class Product { [D...

Can We Auto-generate Controllers and Views Using Dapper

I am working with dapper with c# and mssql . Is there any way that we can autogenerate Controllers and views with dapper as we do with EF....I thought ...DapperExtensions... will work as they specified ...A small library that complements Dapper by adding ...

How do I limit the size of a text field?

I am building my first MVC app, so please excuse me if its a rookie question. I am building a web app that queries an existing SQL database Log tables that are created when a new record is created, mapping the response back using Dapper....However, the Lo...

Automapper vs Dapper for mapping

This question is to verify if the current implementation is the right way to go about in terms of best practices and performance. So far in all my previous companies I have been using Auto Mapper to map relational objects to domain model entities and doma...

Dapper cannot pass the data to the database

I am having a problem where I cannot insert nor update to the database. I am using Dapper and using nested class for the model that I want to pass the data on....I am having an error which is:...The member Information of type TestProject.Models.Informatio...

Passing parameters to Dapper Select query for Oracle database

I'm trying to pass parameters to Dapper for a select query in an Oracle database, but somehow, it doesn't work with the ":" identifier....It works fine using string concatenation :...string req = "SELECT * FROM contact WHERE code_comite = '"; req ...

'Dapper' already has a dependency defined for 'System.Data.SqlClient'

When i tried to install dapper in VS2012 i got this error.

Sequence contains no matching element error when I try to getallUsers()

Hello my question is I have 2 table one is User table the other one is CustomerUsers I select them by Deleted=0 When I try to list all users and have customerId, I am having issue that sequence contains no matching element error... My Code is below any he...

creating Database connection

public class DbConnection { private static string strConnectionString; public string strconn; public static string SqlConnectionStringProp { get { return strConnectionString; } private set { strConnectionString = ...