February 28, 2013 at 12:04 pm
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
. . .
Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?
They are available in Framework 4 and 4.5. You have to include the System.Runtime.Serialization assembly.
Edit: formatting of the quote.
I believe it is also available in 3.5, but I can't include the reference in a C# or VB database project. I can in a Windows Forms project though. I think I need to re-register ServiceModel.exe
I tried WCF projects in both VS 2010 and 2012 and they all have the assembly included in the template.
What type of project are you working with, Stefan?
database in C# or VB. I want to make a CLR, so that seemed like the kind of project to create. Is that wrong?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
February 28, 2013 at 12:08 pm
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
. . .
Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?
They are available in Framework 4 and 4.5. You have to include the System.Runtime.Serialization assembly.
Edit: formatting of the quote.
I believe it is also available in 3.5, but I can't include the reference in a C# or VB database project. I can in a Windows Forms project though. I think I need to re-register ServiceModel.exe
I tried WCF projects in both VS 2010 and 2012 and they all have the assembly included in the template.
What type of project are you working with, Stefan?
Awesome, got it. System.Web.Script.Serialization is available, System.Runtime.Serialization.JSON is not. That should work for now at least. Thanks for the help!
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
February 28, 2013 at 12:30 pm
Stefan Krzywicki (2/28/2013)
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
. . .
Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?
They are available in Framework 4 and 4.5. You have to include the System.Runtime.Serialization assembly.
Edit: formatting of the quote.
I believe it is also available in 3.5, but I can't include the reference in a C# or VB database project. I can in a Windows Forms project though. I think I need to re-register ServiceModel.exe
I tried WCF projects in both VS 2010 and 2012 and they all have the assembly included in the template.
What type of project are you working with, Stefan?
Awesome, got it. System.Web.Script.Serialization is available, System.Runtime.Serialization.JSON is not. That should work for now at least. Thanks for the help!
Just for the heck of it I tried to modify the AdventureCycles Transactions sample. I could add, reference and use Runtime.Serialization without any problem. Code is attached.
February 28, 2013 at 12:37 pm
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
. . .
Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?
They are available in Framework 4 and 4.5. You have to include the System.Runtime.Serialization assembly.
Edit: formatting of the quote.
I believe it is also available in 3.5, but I can't include the reference in a C# or VB database project. I can in a Windows Forms project though. I think I need to re-register ServiceModel.exe
I tried WCF projects in both VS 2010 and 2012 and they all have the assembly included in the template.
What type of project are you working with, Stefan?
Awesome, got it. System.Web.Script.Serialization is available, System.Runtime.Serialization.JSON is not. That should work for now at least. Thanks for the help!
Just for the heck of it I tried to modify the AdventureCycles Transactions sample. I could add, reference and use Runtime.Serialization without any problem. Code is attached.
Thanks, I'll check that out later.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
March 3, 2013 at 1:13 am
Hey guys, I've got a bit of a quandry trying to avoid some recursion while dealing with an XML build. If anyone's willing to spend some time digging through my rambling and code and give me a hand, I'd appreciate the assistance. Even a lmgtfy or "You're SOL" would be helpful at this point, I'm about to see if I can field goal the PC with trebuchet assistance.
http://www.sqlservercentral.com/Forums/Topic1425920-392-1.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 3, 2013 at 12:31 pm
Evil Kraig F (3/3/2013)
Hey guys, I've got a bit of a quandry trying to avoid some recursion while dealing with an XML build. If anyone's willing to spend some time digging through my rambling and code and give me a hand, I'd appreciate the assistance. Even a lmgtfy or "You're SOL" would be helpful at this point, I'm about to see if I can field goal the PC with trebuchet assistance.http://www.sqlservercentral.com/Forums/Topic1425920-392-1.aspx
For better or worse, I took on that.
March 4, 2013 at 9:15 am
Evil Kraig F (3/3/2013)
Hey guys, I've got a bit of a quandry trying to avoid some recursion while dealing with an XML build. If anyone's willing to spend some time digging through my rambling and code and give me a hand, I'd appreciate the assistance. Even a lmgtfy or "You're SOL" would be helpful at this point, I'm about to see if I can field goal the PC with trebuchet assistance.http://www.sqlservercentral.com/Forums/Topic1425920-392-1.aspx
Not sure if what I suggested will help, but I tried.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
March 4, 2013 at 9:45 am
I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this case parsing multilevel XML with multiple occurrences of the same tag, yet prohibits use of a tool that would make it a breeze - in this case XML LINQ via CLR Integration.
March 4, 2013 at 9:48 am
Revenant (3/4/2013)
I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this case parsing multilevel XML with multiple occurrences of the same tag, yet prohibits use of a tool that would make it a breeze - in this case XML LINQ via CLR Integration.
Sorry Revenant. Don't mean to be the cause of your frustration in this case. Clean CLR isn't what scares my DBA's, it's letting my app coders loose with it.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 4, 2013 at 10:03 am
Evil Kraig F (3/4/2013)
Revenant (3/4/2013)
I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this case parsing multilevel XML with multiple occurrences of the same tag, yet prohibits use of a tool that would make it a breeze - in this case XML LINQ via CLR Integration.Sorry Revenant. Don't mean to be the cause of your frustration in this case. Clean CLR isn't what scares my DBA's, it's letting my app coders loose with it.
It was not meant at you, Craig. I have been in that situation and I know how it feels.
March 4, 2013 at 10:44 am
Evil Kraig F (3/4/2013)
Clean CLR isn't what scares my DBA's, it's letting my app coders loose with it.
Oh how things have changed! :w00t:
I remember the days when what scared us developers (users owned the data, of course, but we owned the databases including how the data was represented/mapped into schemata) was letting DBAs have update access to the data (and sometimes even read access). And of course this was even more so when we developers were the users (as with Software CAD systems, Formal Development Methods systems, and so on).
Tom
March 4, 2013 at 12:25 pm
L' Eomot Inversé (3/4/2013)
Evil Kraig F (3/4/2013)
Clean CLR isn't what scares my DBA's, it's letting my app coders loose with it.Oh how things have changed! :w00t:
I remember the days when what scared us developers (users owned the data, of course, but we owned the databases including how the data was represented/mapped into schemata) was letting DBAs have update access to the data (and sometimes even read access). And of course this was even more so when we developers were the users (as with Software CAD systems, Formal Development Methods systems, and so on).
I think the change comes from who's considered on the first contact list, Tom. Most developers these days aren't contacted until well after the DBA is awake, evaluated the errors, and determined its an app error. There's too many environmental things that the devs kick back with 'it works in dev!' that they get stuck with.
In our case, and with a lot of the code that's previously gone through this system (and I admit, a few of my own when I was rushed) I can't blame their paranoia. My office isn't even the worst offender and we make them pretty cagey.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 6, 2013 at 9:29 pm
Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was offsides?"
Well, I've just seen the equivalent here with the question "What is SSMS?"
And you are doing what with SQL Server???
March 6, 2013 at 9:38 pm
Lynn Pettis (3/6/2013)
Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was offsides?"Well, I've just seen the equivalent here with the question "What is SSMS?"
And you are doing what with SQL Server???
A little knowledge can be a dangerous thing. Be afraid, be very afraid! 😛
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
Viewing 15 posts - 39,031 through 39,045 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply