|
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.
|
|
|
|
|
#realJSOP wrote: maybe
Ah, starting to dabble in AI and machine learning. Good. 
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Maybe is programmer talk for too lazy to write the code to put it into one of the other two categories. 
".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
|
|
|
|
|
@code-witch @chris-maunder
JSOP, I congratulate you on this fine example of a Lounge post that is specifically technical in a way that invites discussion, and response, and, that is an example of an update on work-in-progress stated clearly with appropriate enthusiasm unburdened by excessive personal self-glorification
I hope what you are working on may lead to a CP article of the quality of your other contributions !
«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali
|
|
|
|
|
why was i tagged?? 
(Bill of course doesn't have an answer he'll cop to  )
Good old Bill, putting the *passive* in passive aggressive.
Man up, Bill. Say what you wanted to say.
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.
modified 13-Sep-19 2:42am.
|
|
|
|
|
BillWoodruff wrote: that invites discussion
That didn't work out so well. 
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Well, the soapbox is closed, so I had to post it here.
BillWoodruff wrote: I hope what you are working on may lead to a CP article of the quality of your other contributions !
I'm considering it, but it requires a moderate amount of effort to "unworkify" it. I've tried to head some of that off, but, well, you know... Best laid plans, and all that...
".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:14am.
|
|
|
|
|
This happens to me all too often...I ask someone a question, they don't know the answer, but in asking the question I realize either what the answer is or a different way to search for the answer.
This just happened to me now. In desperation, I posted here[^].
I've spent the last couple of days googling for how to deal with the "cached" CSS in dynamic HTML. After asking the question above, I changed my google search to "dynamic html with style" and lo-and-behold, I discovered that there's a CSS Object Model (CSSOM) CSS Object Model (CSSOM) - Web APIs | MDN[^]
And there's methods to delete rules, which solves my problem!
Crazy. It took a minute to ask the question and post it, another 10 seconds to change my google search, and voila, two days (off and on) of google searching reduced to 70 seconds for the solution. 
|
|
|
|
|
|
I need to get me a rubber duck. It's probably smarter than the average developer.
|
|
|
|
|
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Marc Clifton wrote: It's probably smarter than the average developer.
But I am not an average developer! 
This space for rent.
|
|
|
|
|
You do understand there are two adjacent sides to the average - below and above, right?
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
Rick York wrote: You do understand there are two adjacent sides to the average - below and above, right?
No, no he does not.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|
|
Rick York wrote: You do understand there are two adjacent sides to the average - below and above, right?
Well, ok then. The duck is smarter than the majority of developers. And by majority I mean everyone to the left of 3 standard deviations to the right of the mean. 
|
|
|
|
|
Rick York wrote: two adjacent sides to the average
That rings a Bell, but are you trying to be mean? 
This space for rent.
|
|
|
|
|
No, those are my standard, deviant tendencies.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
|
Thanks. 
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
probably more flexible too 
«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali
|
|
|
|
|
|
Marc Clifton wrote: but in asking the question I realize either what the answer is or a different way to search for the answer.
Happens to me all the time. I believe this is actually a technique (formal name eludes me) and works great. Basically talking out your issues, even to a rubber ducky and then you will come up with the answer. Don't really need another real person, most of the time.
Edit: Haha, just read Rick's response. Rubber ducking, yes that is the name/technique.
|
|
|
|
|
Happens all the time to me, too.
And the other way around: When someone comes to me with a problem, and I ask them to explain it in detail, slowly so I can follow it... Sometimes they suddenly exclaim: Oh, I think I know what's wrong! And sometimes, when I watch them I see from their face that the same thing happened, but they say: Maybe I should take some more notes of what happened, and come back to you with more details... (Often I can tell for sure that there is no need to come back - I saw it on your face.)
|
|
|
|
|
You are experiencing the prajñā associated with the bodhi-nature of the yidam Manjushri.
«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali
|
|
|
|
|
Those Buddhists know a thing or two about software development!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
