Mapping char(8) to string property with Dapper

Question

I have the following table, abridged:

CREATE TABLE [dbo].[TERMINAL] (
    [TERM_CODEID]    SMALLINT     NOT NULL,
    [TERM_ACTIVE]    SMALLINT     NOT NULL,
    [TERM_NAME]      VARCHAR (30) NOT NULL,
    [TERM_SLA]       CHAR (8)     NOT NULL,
    [TERM_SERIAL]    VARCHAR (8)  NULL,
    [TERM_VERSION]   VARCHAR (8)  NULL,

    [TERM_STATUS]    INT          NULL,
)

When I try the following Dapper code - and I'm a complete Dapper novice, found it yesterday - I get an error:

using (var conn = new SqlConnection("data source=ourServer; initial catalog=ourDb;user id=sa;password=ourPassword;"))
{
    conn.Open();
    var terms = conn.Query<Terminal>("select * from TERMINAL");
}

The error is:

Error parsing column 3 (TERM_SLA=01010B01 - String)

I can see no reason why anything should even have to 'parse' a string, never mind experience an error while doing so. What could be causing this>

Do your POCO property types match the columns of your datastore? — Alex
– Alex, Commented Jun 11, 2013 at 7:19

Alex · Accepted Answer · 2013-06-11 07:35:37Z

15

Dapper expects the .NET data type to be exactly the same as in your database. Term_Sla needs to be of type String.

answered Jun 11, 2013 at 7:35

Alex

8,1561 gold badge45 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Diallo · Accepted Answer · 2018-10-24 19:07:55Z

1

Here is my experience. i hope this may help, someone:

I had the same error, and .net type was matching the Sql data type; except that some data was null. So make sure that your sql data is not nullable, otherwise adapt your .net property type accordingly.

answered Oct 24, 2018 at 19:07

Diallo

1091 silver badge9 bronze badges

Comments

Ongun23 · Accepted Answer · 2021-05-08 15:38:25Z

0

In my case, there was an enum field and it was not listed in SQL records.

answered May 8, 2021 at 15:38

Ongun23

753 silver badges9 bronze badges

Collectives™ on Stack Overflow

Mapping char(8) to string property with Dapper

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related