Dapper Tutorial - Knowledge Base (KB)

Dapper.SimpleCRUD Insert issue without identity

I have table User...CREATE TABLE [User]( [Id] [int] primary key NOT NULL, [Username] [nvarchar](50) NULL, [EmailID] [nvarchar](50) NULL) ...User class...public class User { public int Id { get; set; } public string Username { get; set;...

Dapper SimpleCRUD custom handlers ignored

If I execute queries with ...SimpleCRUD... i.e., ...connection.GetList<_type>();... , then my custom type handlers are never executed. If I execute the same query directly with ...connection.Query<_type>(queryString)..., then my custom handlers get called...

How to configure Dapper for Multi-tenant tables?

I have multi-tenant table structure whereas each table has ...TenantId... and I am using ...Dapper... as the only ORM along with ...SimpleCRUD... (helper sits on the top of ...dapper...). If possible (by default) I prefer every ...Read Query... MUST pass ...

Dapper.SqlMapper.AddTypeHandler appears not to be called with Postgres SimpleCRUD where clause

I have just upgraded from Npgsql v2.2.3 to v3.2.4.1 (now V3.2.5) on a system using Dapper and SimpleCRUD - other absent developers customised version of latter. Its not really my field - I was just trying to do some PostGIS bits with the v3 support......W...

Getting "The connection does not support MultipleActiveResultSets" in a ForEach with async-await

I have the following code using Dapper.SimpleCRUD :...var test = new FallEnvironmentalCondition[] { new FallEnvironmentalCondition {Id=40,FallId=3,EnvironmentalConditionId=1}, new FallEnvironmentalCondition {Id=41,FallId=3,EnvironmentalConditionId...

Dapper w/ SIMPLECrud: GetList with WHERE behaving like LIKE instead of =

I have this method:... public static IEnumerable<T> GetList(string where, Dictionary<string, object> parameters) { IEnumerable<T> entities; using (var connection = OpenConnection()) { entities = connection.GetLis...

How to convert DapperRow to Dictionary<string,string>

I've a method that returns IEnumerable with Dapper Row. ...But I'm trying to access the data without typecasting it to a particular class and I'm getting null value.

Dapper / SimpleCRUD Insert with VARCHAR primary key throwing FormatException - "The string was not in a correct format"

I am trying to insert into a postgresql database using dapper and simplecrud....My entity has a VARCHAR primary key, which I understand means that I have to include the [Key] and [Required] tags within my POCO....[Table("tube_data")] class Tube : IEntity ...

Dapper SimpleCRUD casts: "Unable to cast object of type 'System.Guid' to type 'System.IConvertible'."

I'm building an API for basic CRUD operations on a database table. I'm using C# in an ASP.NET Web API project and my service classes live in a separate class library. Dapper and Dapper.SimpleCRUD used for ORM operations....When I hard code a guid into the...

Error trying to insert generic with Dapper.SimpleCRUD

I'm trying to create a generic base class for my DataObjects like this :...public abstract class BaseDataObject<TDOType> where TDOType : class { public static TDOType Get(Guid lObjectUUID, NpgsqlConnection conn) { return conn.Get<TDOType>(...

How to use Dapper LINQ with TableDirect (without embedded SQL) with ORACLE?

I tried DapperExtensions, Dapper.Extensions.Linq and linq2dapper to no avail. I will try ...Dapper.SimpleCRUD-with-Oracle.... I will probably settle with a Stored Procedure instead. I want to use ...TableDirect... with no embedded SQL statement. How can I...