3 ms·
What would you like build-in db stuff to be like?
by alexzeitler 4y ago
What would you like build-in db stuff to be like?
- magicalhippo 4y agoWell I mean DataTable and friends can handle master-detail for example, but you gotta do a lot of plumbing to set it all up, especially with autoincs involved. Was kinda expecting it to be less work. Ideally I'd like to supply some selects, fill up some DataTables with master-detail data, manipulate it and commit changes. But yeah, maybe I gotta check out the latest EF stuff and see if I can't convince the others...
- edandersen 4y agoDataTables are a construct from .NET Framework 1.1. You owe yourself (and would be doing your employer a massive favour) to check out EF Core.
- magicalhippo 4y agoWell that'd explain why they feel clunky :D Will def look at it more carefully.
- zip1234 4y agoEF Core: 1. load order and related line items 2. edit anything 3. call SaveChanges() Definitely check it out if you haven't recently!
- andix 4y agoJust do yourself a favor and don’t use datatables directly. If you want to be as close to the database as possible, check out Dapper. It EF core should cover nearly all Dapper functionality and much more.