SqlMarshal icon indicating copy to clipboard operation
SqlMarshal copied to clipboard

Proposal: Advanced ORM Mapping Feature for SqlMarshal

Open pstlnce opened this issue 3 months ago • 1 comments

Hi, I've been following the SqlMarshal project and noticed your roadmap includes implementing ORM functionality to map DbDataReader to objects.

I’ve developed a lightweight ORM that seamlessly maps flat DbDataReader results into nested complex object graphs, automatically resolving properties across multiple levels (as long as naming collisions are avoided or explicitly resolved). It also supports:

  • Custom parsers for specific types or individual properties
  • Flexible column resolution via name(s) or direct column index

This could complement or accelerate your ORM goals. I’d love to discuss integration, collaboration, or contribution opportunities.

Let me know if you'd be interested in.

pstlnce avatar Oct 03 '25 13:10 pstlnce

Hi. I have mixed feelings about it. Firstly I'm glad that you think my library is useful to you. On the other hand, I think that data access layer should be simpler, and probably closer to SQL itself. If I want dehydration to object graph, probably I can/should do that myself.

Given that I care about stored procedures, I may say that this library is for old-school SQL camp.

That's quite conflicting goals, so I do not have clear picture for myself on that one. Obviosuly glad to be convinced to change my mind or maybe just discussing alternative vision for the source generated ORM and how it may look.

kant2002 avatar Oct 03 '25 18:10 kant2002