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

Is there a way to map properties to column names using some .Insert extension method for Dapper?

I have the following challenge with this class:...Public Class MyClass Property Id As Integer Property LastName as String End Class ...The corresponding data table in the database has as fields: ...Id (int, not null)...Last-Name (nvarchar(80),nul...

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

How to Insert/Update an entity when entity type is not known at compile time?

The Dapper.FastCrud uses the generic type argument for ...Insert.../...Update... methods. This works well when the entity types are known at compile time. However, when the entity types are ...not... known at compile time, there seems to be no way to use ...