Click here to Skip to main content
14,429,828 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: would you rather? Pin
Super Lloyd28-Jul-19 17:29
MemberSuper Lloyd28-Jul-19 17:29 
GeneralRe: would you rather? Pin
honey the codewitch28-Jul-19 19:41
mvahoney the codewitch28-Jul-19 19:41 
GeneralRe: would you rather? Pin
Sander Rossel28-Jul-19 22:31
professionalSander Rossel28-Jul-19 22:31 
GeneralRe: would you rather? Pin
NeverJustHere28-Jul-19 22:47
MemberNeverJustHere28-Jul-19 22:47 
GeneralRe: would you rather? Pin
honey the codewitch29-Jul-19 2:35
mvahoney the codewitch29-Jul-19 2:35 
GeneralRe: would you rather? Pin
lmoelleb28-Jul-19 23:07
Memberlmoelleb28-Jul-19 23:07 
GeneralRe: would you rather? Pin
pkfox29-Jul-19 1:21
professionalpkfox29-Jul-19 1:21 
GeneralRe: would you rather? Pin
Marc Clifton29-Jul-19 3:53
communityengineerMarc Clifton29-Jul-19 3:53 
codewitch honey crisis wrote:
1. generate DAL, admin UI and DB from an XML schema source?


That one, except at this point I'd probably use JSON. The problem is, whatever the schema is in, there needs to be a good way to detect changes and migrate those changes to the DB.

#1 has the advantage that additional metadata can be put into it that isn't necessarily captured by the pure DB schema. The problem though is that it can quickly start to look like a UI view definition, which can vary while the schema stays constant. So that trap needs to be avoided, though I don't see any reason why the schema metadata can't define certain defaults, like the default control type to render on the UI.

Also, the DAL is often overkill -- most of the time, you don't need a DAL to serialize the records into class instances, only to map the class properties to UI elements (whether WinForm or web UI's). There's so much automation that can be done (and that I have done) to eliminate the "class" middleman and determine the DB transaction from the table changes directly.

Marc

GeneralRe: would you rather? Pin
honey the codewitch29-Jul-19 4:03
mvahoney the codewitch29-Jul-19 4:03 
GeneralRe: would you rather? Pin
Mark_Wallace29-Jul-19 10:51
MemberMark_Wallace29-Jul-19 10:51 
GeneralRe: would you rather? Pin
honey the codewitch29-Jul-19 10:53
mvahoney the codewitch29-Jul-19 10:53 
GeneralRe: would you rather? Pin
Mark_Wallace29-Jul-19 12:35
MemberMark_Wallace29-Jul-19 12:35 
GeneralRe: would you rather? Pin
honey the codewitch29-Jul-19 12:44
mvahoney the codewitch29-Jul-19 12:44 
GeneralRe: would you rather? Pin
Mark_Wallace29-Jul-19 13:18
MemberMark_Wallace29-Jul-19 13:18 
GeneralRe: would you rather? Pin
honey the codewitch29-Jul-19 13:22
mvahoney the codewitch29-Jul-19 13:22 
GeneralRe: would you rather? Pin
Mark_Wallace29-Jul-19 13:26
MemberMark_Wallace29-Jul-19 13:26 
GeneralRe: would you rather? Pin
honey the codewitch29-Jul-19 13:29
mvahoney the codewitch29-Jul-19 13:29 
GeneralRe: would you rather? Pin
Mark_Wallace29-Jul-19 13:34
MemberMark_Wallace29-Jul-19 13:34 
GeneralC#: Can I trade var for typedef please? Pin
honey the codewitch28-Jul-19 10:31
mvahoney the codewitch28-Jul-19 10:31 
GeneralRe: C#: Can I trade var for typedef please? Pin
Mycroft Holmes28-Jul-19 12:48
MemberMycroft Holmes28-Jul-19 12:48 
GeneralRe: C#: Can I trade var for typedef please? Pin
honey the codewitch28-Jul-19 12:49
mvahoney the codewitch28-Jul-19 12:49 
GeneralRe: C#: Can I trade var for typedef please? Pin
honey the codewitch28-Jul-19 12:50
mvahoney the codewitch28-Jul-19 12:50 
GeneralRe: C#: Can I trade var for typedef please? Pin
Mycroft Holmes28-Jul-19 14:21
MemberMycroft Holmes28-Jul-19 14:21 
GeneralRe: C#: Can I trade var for typedef please? Pin
honey the codewitch28-Jul-19 14:22
mvahoney the codewitch28-Jul-19 14:22 
GeneralRe: C#: Can I trade var for typedef please? Pin
BillWoodruff28-Jul-19 14:55
mveBillWoodruff28-Jul-19 14:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.