ServiceStack.OrmLite for PostgreSQL returning lowercase property names for dynamic sql query that defines PascalCase column names

Question

I have the following dynamic SQL query generated by my code:

SELECT
 "public"."member_contact"."member_id" AS MemberId
 ,  "public"."member_contact"."contact_id" AS ContactId
 ,  "public"."member_contact"."modified_by" AS ModifiedBy
 ,  "public"."member_contact"."lm_prog" AS LmProg
 ,  "public"."member_contact"."created_by" AS CreatedBy
 ,  "public"."member_contact"."cr_prog" AS CrProg
 ,  "public"."member_contact"."id" AS Id
 ,  "public"."member_contact"."modified_date" AS ModifiedDate
 ,  "public"."member_contact"."created_date" AS CreatedDate
FROM "public"."member_contact"

I then run this through a ServiceStack Service Handler method, like so:

var records = await Db.QueryAsync(sqlStatements.SelectStatement, p);, which returns an IEnumerable<dynamic>.

The problem I have is that the records contains the property names in all lowercase (so memberid as opposed to MemberId, etc)

How can I force the IEnumerable<dynamic> to return the property names as per the naming of the columns in the SQL Statement?

This is it exactly! thanks a mil for the pointer...I should have found that one. — Shawn de Wet
– Shawn de Wet, Commented Aug 29, 2024 at 8:43

mythz · Accepted Answer · 2024-08-29 08:35:28Z

1

QueryAsync is Dapper's API.

In OrmLite you can execute Custom SQL with:

var rows = await Db.SqlListAsync<MemberContact>(sql);

The Dynamic ResultSets also lists other ways you can execute custom SQL queries.

answered Aug 29, 2024 at 8:35

mythz

144k31 gold badges253 silver badges400 bronze badges

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

Collectives™ on Stack Overflow

ServiceStack.OrmLite for PostgreSQL returning lowercase property names for dynamic sql query that defines PascalCase column names

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related