Dapper Tutorial - Knowledge Base (KB)

What POCO entities generator utilities exist for DAPPER?

I am switching a repository layer from linq to dapper. In linq, I can use the SqlMetal.exe tool to generate the database entities and relationships. Is there a tool or utility that will generate POCO entities for dapper?

POCO One-To-One, micro ORM. Should I store ref id or only ref object?

Should I store ref id to child Poco or only ref object in Model when using micro ORM like Dapper (in Repository)? I think that if I store both there will be synchronization issue when updating root object. ...For example:...Class Boat +Id +LakeId ...

Best practices to manage entities while querying the data out of tables?

Each table in my database has it's own ...POCO... class. Now, I have started to write complex SQL joins and the query resultset should be mapped to some Entity which can be sent to the Business Manager (another layer) for further processing. For an exampl...

C#, Dapper, POCO and Encrypt/Decrypt

I have this POCO class:...class Users { public string User { get; set; } public string Password { get; set; } private string Encrypt(string plainText) { ... return encryptedText; } private string Decrypt(string cip...

readonly POCO that always represents database state

As of Dapper 1.50.5 this feature has been added to allow readonly properties (getter, no setter) to be set by Dapper: ...Does Dapper support c# 6 read-only properties in POCOs?...This is good because I want objects never modified by anything except the co...