Click here to Skip to main content
15,895,557 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.

 
GeneralAmazon announces new "Prime Instant" delivery service Pin
BillWoodruff12-Sep-19 15:49
professionalBillWoodruff12-Sep-19 15:49 
GeneralRe: Amazon announces new "Prime Instant" delivery service Pin
Daniel Pfeffer13-Sep-19 1:40
professionalDaniel Pfeffer13-Sep-19 1:40 
RantWhy oh why Pin
Lutosław12-Sep-19 11:26
Lutosław12-Sep-19 11:26 
GeneralRe: Why oh why Pin
honey the codewitch12-Sep-19 14:40
mvahoney the codewitch12-Sep-19 14:40 
GeneralRe: Why oh why Pin
the goat in your machine12-Sep-19 16:24
the goat in your machine12-Sep-19 16:24 
GeneralRe: Why oh why Pin
Dominic Burford12-Sep-19 21:45
professionalDominic Burford12-Sep-19 21:45 
GeneralRe: Why oh why Pin
RickZeeland13-Sep-19 0:50
mveRickZeeland13-Sep-19 0:50 
GeneralDataTable Model/ViewModel Code Generator Pin
#realJSOP12-Sep-19 10:35
mve#realJSOP12-Sep-19 10:35 
After four days, I have the following working:

- Get list of stored procs and their parameters from specified database
- Establish a reasonably confident indicator regarding whether or not each stored proc returns a dataset (three states, yes, no, and maybe)
- Display store procs in a listview with the dataset indicator
- User can provide values for stored proc params(interface looks like the one in SQL server)
- Execute selected stored proc, and returned columns displayed (with types) in a list view
- User can generate model code with optional attribute decoration for model properties that can be saved back to database
- User can generate viewmodel code for WPF or non-WPF target apps

TO-DO:
- Wire up the model property attribute support
- Implement code to bulk-generate code for all stored procs simultaneously that definitely return a dataset

I had to make assumptions regarding the presence of associated assemblies regarding attributes and WPF (this is for work, but can easily be adapted to any dev ecosystem).
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013


modified 13-Sep-19 7:00am.

GeneralRe: DataTable Model/ViewModel Code Generator Pin
ZurdoDev12-Sep-19 11:02
professionalZurdoDev12-Sep-19 11:02 
GeneralRe: DataTable Model/ViewModel Code Generator Pin
#realJSOP12-Sep-19 13:21
mve#realJSOP12-Sep-19 13:21 
GeneralRe: DataTable Model/ViewModel Code Generator Pin
BillWoodruff12-Sep-19 16:07
professionalBillWoodruff12-Sep-19 16:07 
GeneralRe: DataTable Model/ViewModel Code Generator PinPopular
honey the codewitch12-Sep-19 20:32
mvahoney the codewitch12-Sep-19 20:32 
GeneralRe: DataTable Model/ViewModel Code Generator Pin
ZurdoDev13-Sep-19 0:54
professionalZurdoDev13-Sep-19 0:54 
GeneralRe: DataTable Model/ViewModel Code Generator Pin
#realJSOP13-Sep-19 1:05
mve#realJSOP13-Sep-19 1:05 
GeneralWhen asking a question you suddenly realize the answer... Pin
Marc Clifton12-Sep-19 8:51
mvaMarc Clifton12-Sep-19 8:51 
GeneralRe: When asking a question you suddenly realize the answer... Pin
RickZeeland12-Sep-19 8:56
mveRickZeeland12-Sep-19 8:56 
GeneralRe: When asking a question you suddenly realize the answer... Pin
Marc Clifton12-Sep-19 9:02
mvaMarc Clifton12-Sep-19 9:02 
GeneralRe: When asking a question you suddenly realize the answer... Pin
Kevin Marois12-Sep-19 9:41
professionalKevin Marois12-Sep-19 9:41 
GeneralRe: When asking a question you suddenly realize the answer... Pin
DRHuff12-Sep-19 10:08
DRHuff12-Sep-19 10:08 
GeneralRe: When asking a question you suddenly realize the answer... Pin
Rick York12-Sep-19 11:34
mveRick York12-Sep-19 11:34 
GeneralRe: When asking a question you suddenly realize the answer... Pin
Michael Martin12-Sep-19 12:45
professionalMichael Martin12-Sep-19 12:45 
GeneralRe: When asking a question you suddenly realize the answer... Pin
Marc Clifton13-Sep-19 2:34
mvaMarc Clifton13-Sep-19 2:34 
GeneralRe: When asking a question you suddenly realize the answer... Pin
DRHuff13-Sep-19 3:25
DRHuff13-Sep-19 3:25 
GeneralRe: When asking a question you suddenly realize the answer... Pin
Rick York13-Sep-19 4:57
mveRick York13-Sep-19 4:57 
GeneralRe: When asking a question you suddenly realize the answer... Pin
DRHuff13-Sep-19 5:27
DRHuff13-Sep-19 5:27 

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.