|
I'm using a .sqlproj for my database. It lets you create tables using a semi-designer UI which is nice. However it tries to limit the amount of SQL it generates to reproduce the designer which can be a problem; in particular with default value constraints if you need to generate update scripts instead of always publishing to the DB in VS itself (eg because you're distributing a desktop app instead of a website). Eg this is what I get by default.
[IsDirty] bit NOT NULL DEFAULT 0
Looks harmless right?
Except that when you publish, in SQL Server you get a generated constraint with a name like DF__UserPermi__IsDir_49ACE3F2B. Even this could be livable, except that the number on the end is randomly generated and consequently multiple create scripts will result in different postfixes on the constraint names. This in turn results in databases that whenever a constraint is touched (and the sqlproj's love of dropping constraints while doing anything else to a table means this is more often than you might otherwise thing) you can't have a single universal update script.
If MS had gone with full table and column names in its generated constraint names instead of truncating and affixing a random 8 digit hex number this wouldn't've mattered.
If MS would've used randoms and truncation (presumably to maintain a max length) and then put the name in the SQL it generates to describe the table in the .sqlproj it wouldn't've mattered.
Since they did neither of those things I just wasted 2.5 hours of my life modifying hundreds of lines of SQL to look like this instead:
[IsDirty] bit NOT NULL CONSTRAINT [DF_UserPermissions_IsDirty] DEFAULT 0
ELEPHANTING SUNSHINES!
And for more fun down the line, AIUI there's no way to automatically enforce explicit naming of new constraints (never mind actually have the project do the explicit naming for us). I shudder to think of what would happen if we ended up repeating the original problem with hundreds or thousands of systems deployed in the future instead of just a handful of beta testers.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging 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
|
|
|
|
|
do you have that many contraints that you need to adjust for updates every time?
Do that many of your update scripts really need to violate [default value] constraints? (Sounds a bitreally bodgy)
just hand script the few that matter (- there should be clear records of those few, if any, that matter)
- if it is a huge number rethink the design because that is nothing to ever brag about.
Sin tack
the any key okay
|
|
|
|
|
In reality I suspect at least 99% of the time the constraints could be left in place (actually I can't think of any thing I've done since starting the app that would require removing one); but the update scripts that .sqlproj generates frequently decide to add/remove constraints before doing anything with the table. Once again Elephanting Microsoft Sunshines.
Theoretically I could edit every update script it generates to remove the add/remove constraint elephantery, but that would end up being an even bigger cumulative waste of time.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging 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
|
|
|
|
|
Did sound odd to me to keep flipping constraints in and out, but if it's from a script builder then as you say sensibility is also removed.
I guess I'm old fashioned and don't use auto generated scripts: if they work fine, but when they fail finding out where is somewhere on-par with looking at junior programmer multi threaded recursive class libraries in visual basic.
|
|
|
|
|
I'm not sure this'd be my first choice project either; but my employer's decided to standardize on a single .net DB project type to minimize the differences in tooling between different projects and .sqlproj was the favorite of the senior dev who decided what we'd have to use. Funny how that works. 
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging 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
|
|
|
|
|
|
That's to hold his spare Flux Capacitors [^].
If you think 'goto' is evil, try writing an Assembly program without JMP.
|
|
|
|
|
If your couch starts saying "I think therefore I am" is it a philosofa?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Hmmm, I'll have to sleep on that.
Sin tack
the any key okay
|
|
|
|
|
Wasn't it 'I sink, therefore I am' on the Titanic?
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
Whoever dinette, that's just pillow talk.
| 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 are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
If your sofa starts talking you need to go to bed and sleep it off.
... such stuff as dreams are made on
|
|
|
|
|
To err is Human, to think - divan.
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|
|
Oy, these simple puns, you're getting la-z-boy.
If you think 'goto' is evil, try writing an Assembly program without JMP.
|
|
|
|
|
A talking couch would likely be king of the ottoman empire.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
|
|
Ramin Djawadi - Game Of Thrones Main Theme (Extended)[^]
I finally decided to watch Game of Thrones about two weeks ago.
I wanted to wait until all seasons were available, but I just couldn't wait any longer.
Awesome show, can't stop watching (must... not... binge watch...  )
Responsibilities are piling up, but I'm at season 3 so in another three weeks time I've caught up and life can continue as it always has  / 
Anyway, sound of this week is the Game of Thrones main theme
|
|
|
|
|
it gets easier not to watch as you go on - slow, predictable, milking milking milking.
(and probably less nudie biits because too many people complained - and given what they calimed was there ost of the complainers never watched it anyway... oops soapboxing, will stop n
Sin tack
the any key okay
|
|
|
|
|
Lopatir wrote: and probably less nudie biits because too many people complained
Then what's the point of watching? 
Jeremy Falcon
|
|
|
|
|
A season is just 10 episodes. Why do you need 3 weeks for the remaining 3 seasons? 
|
|
|
|
|
I bet he's one of those weirdos who has a "life". 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
By the sounds of it, I wouldn't want to be saddled with anything like that.
|
|
|
|
|
At least I pretend to have one
So I'm off now to do uhhh... stuff that people with lives do, you wouldn't understand
|
|
|
|
|
Top 10..... things.
Number 10 – Death is the No. 1 killer in the world.
Number 9 – Life is sexually transmitted.
Number 8 – Good health is merely the slowest possible rate at which one can die.
Number 7 – Men have two emotions: hungry and amorous, and they can’t tell them apart. If you see a gleam in his eye, make him a sandwich.
Number 6 – Give a person a fish and you feed them for a day. Teach a person to use the Internet and they won’t bother you for weeks, months, maybe years. And give them a cell phone with all the bells and whistles and you may never see them again.
Number 5 – Health nuts are going to feel stupid someday, lying in the hospital, dying of nothing.
Number 4 – All of us could take a lesson from the weather. It pays no attention to criticism.
Number 3 – In the ’60s, people took acid to make the world weird. Now the world is weird, and people take Prozac to make it normal.
Number 2 – Life is like a jar of jalapeno peppers. What you do today might burn your butt tomorrow.
Number 1 – Don’t worry about old age — it doesn’t last that long
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
