Welcome to the Lounge

4-May-20 1:26

So, I've been working on this app that will generate model and viewmodel classes from stored procs in the specified database. It's intended for folks like me, that abhor the thought of using a UDM, or that find the ADO.Net project in Visual Studio to the quagmire of failure that it is.

Every time I think I've reached a point where I think I'm finally done, I think of something else that really must be included in the app.

0) It would be nice if I could do the same thing with tables and views. Result : a new wizard page, a new window, and a crapload of refactoring in the code generator. Thought I was finally done...

1) I decided to try out the long-ignored stored proc generator. Result: new window to handle procs with input parameters, and fixing some generator code. Thought I was finally done...

2) I decided I wanted to add more flexibility where the viewmodel generation was concerned. Result: Completely refactoring the settings wizard page, adding a help window for viewmodel settings, and adding code to react to the new settings. Thought I was finally done...

3) Item #3 is boycotted today. This item will not appear in any of my enumerated lists for the remainder of the day.

4) It might be nice to add properties that provide CRUD queries for tables. Result : adding code to the code generator that does creates the queries, and adding a number of new app settings to allow some flexibility. Thought I was finally done...

5) In the process of adding the CRUD stuff, a dilemma arose regarding how to identify the column that would control update and delete functionality. Originally, I looked for a column with the text "ID" in it. I sat there looking at the code, and thought, "Not everybody is as pragmatic as I am in their column naming habits, so I, after a little research, I discovered that the ADO DataColumn object contained properties to help you find columns that auto-increment and that are read-only. So, I changed the code to retain and look for those properties to identify the most likely ID column. The whole detection code block turned into a three-tier setup, where I look for the autoincrement/readonly column, fall back to one that looks for "ID" in the name, and then finally, simply use the first column in the returned schema.

Unless you count testing, testing, and more testing, and then writing the actual article series, I think I'm finally done...

Famous last words, right?

".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 4-May-20 10:08am.

RickZeeland4-May-20 1:37

RickZeeland

4-May-20 1:37

Maybe a nice idea to make it a cross-platform app $Shucks | :-\$

#realJSOP4-May-20 1:50

4-May-20 1:50

It's got a WPF UI, so there's no hope of that happening. Smile | :)

Nelek4-May-20 1:55

Nelek

4-May-20 1:55

I thought that what .Net Core is for...

M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

#realJSOP4-May-20 2:11

4-May-20 2:11

.Net core is for commandline apps. If your app has a UI (WinForms or WPF), running in different versions of Windows is about as "cross-platform" as it gets.

They can't make a WPF layer because linux has a crap-ton of different compositors and graphics engines. Microsoft can't just pick one to support/endorse, but at the same time, they can't possibly support them all, so they chose the lazy path and decided not to do anything.

kalberts4-May-20 3:50

kalberts

4-May-20 3:50

This is like Docker on Windows: Consider it CLI only.

Well, a container might have an HTML interface, but that is not exactly like WPF.

In principle, I guess you in principle could create a container where UI libraries were replaced by stubs code running the Windows Remote Desktop protocol. The container would probably approach Windows itself in size. (Don't consider it a serious proposal Smile | :)

)

Linux people would say: Why don't you just do it our way - you could be using X11, then everything would be fine! ... Try telling Linux affecionados that they could simply implement the Windos way in Linux, abandoning X11, and listen to the reaction you get Smile | :)

#realJSOP4-May-20 4:02

4-May-20 4:02

Using docker containers is a) more work than it's worth, and b) running in a docker container STILL won't let the app run in Linux.

Using .Net Core would add NOTHING tangibly positive to a WPF or WinForms app. Since it's not a web app, I'm not even sure why you mentioned it.

Dan Neely4-May-20 2:46

Dan Neely

4-May-20 2:46

You can run WPF (or WinForms, or UWP) on .net core; but since it's just a wrapper for a bunch of Win32 UI libraries your application will only work on Windows because other platforms don't support the lower level dependencies.

Or won't until someone gets bored enough to package the libraries for WINE up nicely into a format that .net core can natively use anyway.

Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius

Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt

#realJSOP4-May-20 4:06

4-May-20 4:06

WPF has been around since about 2009, and WINE *still* doesn't support it, as is evidenced by Wine's inability to run Visual Studio 2010 and newer (when they change the UI over to WPF).

Until Microsoft gets off their ass and provides the necessary graphics layers for use on Linux (which also won't ever happen), .Net Core is only "cross-platform" for CLI apps.

Mycroft Holmes4-May-20 12:54

Mycroft Holmes

4-May-20 12:54

#realJSOP wrote:
Every time I think I've reached a point where I think I'm finally done,

I pinched one of these from a guy in the 90s, I only stopped fiddling with it when I retired 20 years later. I still ran it from the debug build.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

kmoorevs5-May-20 4:46

kmoorevs

5-May-20 4:46

#realJSOP wrote:
I think I'm finally done...

Ha! John, you've been at this long enough to know that software is never done. Laugh | :laugh:

"Go forth into the source" - Neal Morse

#realJSOP5-May-20 8:06

5-May-20 8:06

Yeah, software is like project cars. Smile | :)

Why Dark-Side Bob?

W∴ Balboos, GHB4-May-20 1:04

W∴ Balboos, GHB

4-May-20 1:04

Well - before I posted I checked for today in history:

Machiavelli was born - but I don't think that's it. Maybe, something more like:

Quote:
1979 Margaret Thatcher becomes the first woman to be elected Prime Minister of the United Kingdom

Ravings en masse^
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

musefan4-May-20 1:08

musefan

4-May-20 1:08

...because a Luke Skywalker wig would look crap on Bob.

W∴ Balboos, GHB4-May-20 1:17

W∴ Balboos, GHB

4-May-20 1:17

I wasn't thinking about a wig for him - but now that you got me thinking, quite an assortment of them would be worth a try:

Harry Potter
Kim Jong-Un
Bo Derrick
Telly Savalas
Dilbert's Boss
Martha Stewart
Chris Maunder

Ravings en masse^
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

Do not escape reality : improve reality !

Rage4-May-20 1:30

Rage

4-May-20 1:30

W∴ Balboos, GHB wrote:
Chris Maunder

Ah ! I think we might be on something here ! @sean-ewington, please make that happen, a Chris-shaped Bob. Laugh | :laugh:

Sean Ewington4-May-20 3:34

Sean Ewington

4-May-20 3:34

The image this conjures in my mind disturbs me. I don't know if I have the strength to bring it to life.

Thanks,
Sean Ewington
CodeProject

modified 4-May-20 12:33pm.

#realJSOP4-May-20 1:27

4-May-20 1:27

I think the metal bikini would be hilarious, though. LOL

Do not escape reality : improve reality !

Rage4-May-20 1:31

Rage

4-May-20 1:31

Did I miss the episode where Luke was wearing a metal bikini ?

ZurdoDev4-May-20 1:51

ZurdoDev

4-May-20 1:51

Rage wrote:
Did I miss the episode where Luke was wearing a metal bikini ?

The more important question is, are you upset that you missed that episode?

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.

#realJSOP4-May-20 2:16

4-May-20 2:16

Liea's bikini when she was Jaba's slave girl.

Nelek4-May-20 1:52

Nelek

4-May-20 1:52

As long as it is not Sean's Mankini... Roll eyes | :rolleyes:

M.D.V.