Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9013,9023,9033,9043,905»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 3:18 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 2,749, Visits: 7,153
Steve Jones - SSC Editor (2/27/2013)
Stefan Krzywicki (2/27/2013)


I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?


Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr


Thanks, I'll take a look


--------------------------------------
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
Post #1424789
Posted Wednesday, February 27, 2013 3:25 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 12,877, Visits: 31,791
Steve Jones - SSC Editor (2/27/2013)


Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr


wow we use Trello in our shop, and were talking about automating the creation of cards in parallel to our internal work order system.
this is well timed, thanks Steve


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1424790
Posted Wednesday, February 27, 2013 3:27 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 2,749, Visits: 7,153
Lowell (2/27/2013)
Steve Jones - SSC Editor (2/27/2013)


Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr


wow we use Trello in our shop, and were talking about automating the creation of cards in parallel to our internal work order system.
this is well timed, thanks Steve


Cool, now you ask a question so I can get a perfectly timed answer.

I actually think I have a good start, but need to install or activate AJAX on the machine.


--------------------------------------
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
Post #1424793
Posted Wednesday, February 27, 2013 3:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:33 AM
Points: 33,051, Visits: 15,161
Lowell (2/27/2013)
Steve Jones - SSC Editor (2/27/2013)


Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr


wow we use Trello in our shop, and were talking about automating the creation of cards in parallel to our internal work order system.
this is well timed, thanks Steve


YW, let me know if it works. Passed it along to our group internally as well.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1424797
Posted Wednesday, February 27, 2013 5:14 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:21 PM
Points: 11,192, Visits: 11,090
Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?

Have at look at these:

http://www.amazon.com/Expert-SQL-Server-2005-Development/dp/159059729X (not the 2008 version!)
http://www.amazon.com/Server-2005-Assemblies-Experts-Voice/dp/1590595661

If the target is SQL Server 2008:

http://msdn.microsoft.com/en-us/library/system.runtime.serialization.json.datacontractjsonserializer(v=vs.90).aspx

You might find this article interesting too:

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1424818
Posted Wednesday, February 27, 2013 6:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 2,749, Visits: 7,153
Paul White (2/27/2013)
Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?

Have at look at these:

http://www.amazon.com/Expert-SQL-Server-2005-Development/dp/159059729X (not the 2008 version!)
http://www.amazon.com/Server-2005-Assemblies-Experts-Voice/dp/1590595661

If the target is SQL Server 2008:

http://msdn.microsoft.com/en-us/library/system.runtime.serialization.json.datacontractjsonserializer(v=vs.90).aspx

You might find this article interesting too:

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/


Thanks! I'll take a look.


--------------------------------------
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
Post #1424832
Posted Thursday, February 28, 2013 9:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 2,749, Visits: 7,153
Paul White (2/27/2013)
Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?

Have at look at these:

http://www.amazon.com/Expert-SQL-Server-2005-Development/dp/159059729X (not the 2008 version!)
http://www.amazon.com/Server-2005-Assemblies-Experts-Voice/dp/1590595661

If the target is SQL Server 2008:

http://msdn.microsoft.com/en-us/library/system.runtime.serialization.json.datacontractjsonserializer(v=vs.90).aspx

You might find this article interesting too:

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/


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?


--------------------------------------
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
Post #1425097
Posted Thursday, February 28, 2013 11:04 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:38 AM
Points: 4,379, Visits: 3,391
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.
Post #1425208
Posted Thursday, February 28, 2013 11:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 2,749, Visits: 7,153
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


--------------------------------------
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
Post #1425216
Posted Thursday, February 28, 2013 12:02 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:38 AM
Points: 4,379, Visits: 3,391
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?
Post #1425237
« Prev Topic | Next Topic »

Add to briefcase «««3,9013,9023,9033,9043,905»»»

Permissions Expand / Collapse