Dapper Tutorial - Knowledge Base (KB)

DatabaseGeneratedOption doesn't work in Dapper.FastCRUD

I setup my mapping like this:...[Table("Opportunity")] public partial class Opportunity { // Other columns ... [Key] [Column(Order = 1)] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public long OPPORTUNITY_ID { get; set; ...

using dapper to insert with stored procedure ( maybe tvp )

I have a model PersonalInfo like so:...public string FirstName { get; set;} public string LastName { get; set;} public string Email { get; set; } public IEnumerable<Addresses> Addresses{ get; set; } ...And my Addresses model include something like:...publ...

How to map C# enum to PostgreSQL enum using Dapper.FastCRUD?

I have a class ...Sample..., one of whose properties is an enum, ...TargetType.... I have a corresponding table ...samples... defined in a PostgreSQL database, along with a matching enum type, ...targettypes.......With Dapper.FastCRUD, I can retrieve reco...

Sqlite using Dapper. Error parsing column . Unable to cast object of type System.Int64 to type System.Double

I'm using fastcrud and dapper to map my query results to my custom type. I investigated the dapper library and i came to the conclusion that i think it's an issue with the Microsoft.Data.Sqlite package. Not sure if it must be fixed over there but this is ...

Dapper FastCRUD with object inheritance

I am using Dapper FastCRUD for insert/update for my project. I have a entity which inherits from another entity. Both of them have separate destination tables, annotated with TableAttribute. Is there a way to save data to both the tables using Fast CRUD, ...

Create domain partition with Dapper FastCrud ModelGenerator

Our Sql Server database has multiple schemas/owners. Some of the table names are identical without the schema so when configuring the Model Generator I would like to be able to either filter by schema or append the schema name to the table so there is no ...

create query for mysql in Dapper FastCRUD

I want to use dapper fastcrud(DLL FOR CRUD Operation in dapper) with mariadb(mysql engine) but when i want to execute my code I have syntax Error ...It seems when fastcrud wants to create query ,it's default behaviour is creating query appropriate for s...

dapper.fastcrud doesn't mapped geometry data from postgresql

I have a spatial data in Postgresql. For example table planet_osm_point has 2 attributes:...CREATE TABLE public.planet_osm_point ( osm_id bigint, way geometry(Point,3857) ) ...If I use dapper to CRUD operations all work fine. But if I use Dapper.f...