Dapper Tutorial - Knowledge Base (KB)

Why does using Linq's .Select() return IEnumerable<dynamic> even though the type is clearly defined?

I'm using Dapper to return dynamic objects and sometimes mapping them manually. Everything's working fine, but I was wondering what the laws of casting were and why the following examples hold true....(for these examples I used 'StringBuilder' as my know...

How to convert List<Dapper.SqlMapper.FastExpando> to runtime type (List<IDictionary<string,object>>)

I'm using a method that has a return signatur of ...IEnumerable<dynamic>.... At runtime for a particular call it is returning ...List<Dapper.SqlMapper.FastExpando>.......var x0 = repo.Find(proc, param); //x0 runtime type is {List<Dapper.SqlMapper.FastExp...

Cast Class Type at Runtime in VB.NET

I have looked at dozens of answers, and ...three...of...them... seem really close to what I'm trying to achieve....I have a database with hundreds of views. I use dapper to query the results of a view. I present the results in a grid. This is a read-only ...

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

Casting IEnumerable<dynamic> with custom class

I've been using dapper lately and wanted to make a dynamic method that would make it easier to select things out with sql. This is my code:...Class:...public class Method { public static IEnumerable<dynamic> QueryAll(string table) { dynam...