Dapper Tutorial - Knowledge Base (KB)
24 results in tag: mapping
Can the multimapping of Petapoco handle multiple JOINs?
I have a list objects I use to fill using Petapoco....The class properties and names are maching the database schema. The main class is ...Issue..., and it is related to two other classes which names and properties matches the database schema too : ...Con...
asked by Larry
Unexpected behaviour with a multi-mapping query using Dapper.net
I've only just started looking at Dapper.net and have just been experimenting with some different queries, one of which is producing weird results that i wouldn't expect....I have 2 tables - ...Photos... & ...PhotoCategories..., of which are related on ..
asked by marcusstarnes
Dapper.NET multi mapping TSecond Deserializer is null
I'm trying to perform a very standard multi mapping query using Dapper, and I'm getting the following error. I also get another error occasionally when this seems to work, but I'm unable to reproduce it at the moment. I'll append it to this post if/when t...
asked by George
Mapping entity in Dapper
I've just started working with Dapper and I don't seem to find something very simple like mapping an entity to a table in my database:...I have a stored procedure:...CREATE PROCEDURE [dbo].GetUserById (@UserId int) AS begin SELECT...
asked by David Aleu
Mapping 4 Tables to a single Object in Dapper
I have a quick question about Dapper. I have a query that returns 4 tables....Three tables have just one integer column. Call them field1, field2, and field3....The 4th table has 5 columns say: A,B,C,D,E....I have made an object called ...ResultSet... tha...
asked by vighnu
Mapping SqlGeography with Dapper
I have entity "Point", that contains Id, Text and geography coordinates. ...CREATE TABLE [Point] ( [Id] INT IDENTITY CONSTRAINT [PK_Point_Id] PRIMARY KEY, [Coords] GEOGRAPHY NOT NULL, [Text] NVARCHAR(32) NOT NULL, [CreationDate] DATETIME N...
asked by lenden
Dapper ORM and SQLite perform query
I've got a simple table in my SQLite database:...CREATE TABLE ProductCategories ( Id INTEGER PRIMARY KEY AUTOINCREMENT, Name NVARCHAR(128) NOT NULL UNIQUE, ImageUrl NVARCHAR(256), ParentCategoryId INTEGER, FOREIGN KEY (ParentCategoryId...
asked by shadeglare
Error mapping dapper with an enum + sqlserver
I have a class:... public class Member { #region public property public int Id { get; set; } public string LastName { get; set; } public string FirstName { get; set; } public string Email { get; set; } public string Password { g...
asked by user1428798
Dapper mapping column with a property in the model having a different name and type
I have a model this model: ... public class Member { #region public property public int Id { get; set; } public string LastName { get; set; } public string FirstName { get; set; } public AccountState AccountSta...
asked by user1428798
Map SQL columns in SqlMapper.Query<T1,T2,TReturn> to class properties
First I do not have much experience with dapper.net and maybe this problem has simple solution....I would like use multi mapping features....I simplified my problem....I have 2 tables....First table ...CARS...Columns:...CARD_ID (PK)...CAR_LOCATION...CAR_S...
asked by trust in wpf
Extending Query<T, ..> to more than 7 types
I am using Dapper to fetch a list of results. I have a lot of "value"-tables that only contains ID and a name....I have this SQL;...SELECT MedicationScheduleItem.*, MedicationSchedule.*, Patient.*, Medication.*, MedicationBrand.*, ...
asked by TryingToImprove
dapper .net mapping with duplicate model properties for splitOn
I have two Model with same property name as...Class Office<br> { int Id; string Name; Location Location; } Class Location { int Id; string Name; } sqlConnection.Query<Office, Location, Office>("query", (o, l) => {o.Location=l}, splitOn="I...
asked by dip
model isn't working as expected C#
My model is getting data I need, but I'm not sure how to organize it in the way I need. I have it where the model pulls a team, and a player. The issue is when mapping my data to the model it gives me duplicate teams, and doesn't allow me to call players ...
asked by alphamalle
How to get Dapper to ignore/remove underscores in field names when mapping?
There are many ways to map database field names to class names, but what is the simplest way to just remove the underscores?... public IEnumerable<PersonResult> GetPerson(int personId) { using (var dbConnection = _dbConnectionFactory.Create...
asked by scw
Dapper Property Types
If I have a table such as the following: ...CREATE TABLE MYTABLE ( ID NUMBER(15) NOT NULL CONSTRAINT IFS_ROUTINE_ADGROUP_PK_PRIM PRIMARY KEY, NUMBER_COLUMN NUMBER(15) NOT NULL, TEXT_COLUMN VARCHAR2 (50) NOT NULL ) ; ...If I have one singl...
asked by ClayKaboom
How to exclude all virtual properties from classes inheritted from ClassMapper<T> by default?
I have a lot of POCO classes that contain several virtual properties each. Something like this:...public class Policy { public int Id { get; set; } public int EntityId { get; set; } public int ProgramId { get; set; } public string PolicyN...
asked by Red
Dapper: String is passed on as Text when invoking postgres functions
When calling a DB function in Postgres, the type for ...String... changes to ...text... and that of ...DateTime... to ...timestamp.... Is there any way to ensure this doesn't happen? ...Setup: a DB function:...foo(v_from character varying, v_to character ...
asked by Achilles
Dapper Extensions dbConnection.Get<Object>
Problem with: Dapper Extensions dbConnection.Get(personId)...I have a model called Person:...Person { public int PersonId { get; set; } public string Name { get; set; } } ...In the database I have this table:...data.Persons Pers_Id Pers_Na...
asked by doper1234
Dapper not throwing an exception when select query does not contain expected column
When using Dapper as follows:...connection.Query("select a from Foo").Select(x => new Foo(x.a, x.b)); ...My preference is that an exception is thrown when trying to access x.b, rather than it just returning null....I understand that just returning null ma...
asked by fractor
Dapper map multiple joins Sql Query
I want to map complex object to dapper result from query which has two inner joins. I know we've solution to map one inner join but I want to map two inner joins result....Here is the Scenario:...My Classes are:...public class Order { public int id {...
asked by Saadi
Page 1 of 2