Wow--Create class objects directly from SQL Server

I've been planning to create the middle tier of a project I'm developing as an ASP .NET WebService.  The goal of the webservice is to provide a strongly-typed set of class objects to the calling program in such a way that the calling program needs no knowledge of the underlying database. I got the idea from working with SQL Server Reporting Services. I still have a couple of technical challenges to face (which I look forward to), such as how to provide databinding support.

I've been reading Dino_Esposito's_book on XML Programming, and he talks quite a bit about de/serializing objects from XML.  Separately, he discusses pulling XML documents and fragments directly from SQL Server using SQL Server's native XML support.  The thought then occurred to me, “why can't I deserialize objects directly from xml queries to SQL Server? That would be awesome!”  Apparently, Dino had the same thought.  Way to go Dino!  If you happen to read this, thanks a lot for the work you've done in this area.  This is going to make a lot of things a lot simpler for me in the future!

Comments

# re: Wow--Create class objects directly from SQL Server

Tuesday, April 20, 2004 11:54 AM by Dave Burke

Chris, Dino's book on XML Programming is the favorite book on my shelf. (Or I should say, in my car, since I carry it with me in case I have down time out and about.) I particularly enjoyed the serialization chapters and am looking forward to moving in the same direction you describe here. Thanks for the post!

# re: Wow--Create class objects directly from SQL Server

Tuesday, April 20, 2004 1:17 PM by Bryant Likes

I agree SqlXml + Serialization is very cool :)

I posted the results of some performance tests that I did and you don't take too much of a hit doing the whole Xml/Deserialize/Object thing compared to the standard object hydration methods.

http://blogs.sqlxml.org/bryantlikes/archive/2003/11/18/226.aspx

# re: Wow--Create class objects directly from SQL Server

Tuesday, April 20, 2004 1:19 PM by Bryant Likes

Also, if you get into deserializing objects with images check out:

http://blogs.sqlxml.org/bryantlikes/archive/2003/11/17/220.aspx

#

Tuesday, April 20, 2004 5:56 PM by TrackBack

<p>
<a href="http://weblogs.asp.net/taganov">Chris</a> takes <a href="http://weblogs.asp.net/taganov/archive/2004/04/20/116692.aspx">a look at a different way to interact with SQL Server</a> - using sqlxml and .Net xml serialization. I remember seeing this thing for the first time about a year ago, and I too had an "egad !" type moment. Could SQL Server act as an OO DB ?!
</p><p>
After much pondering, then some thinking, a bit of checking, and thinking some more, I came up with <i>an</i> answer ( not <b>the</b> answer, just an answer ). The answer is, unfortunately, no. There's more to bridging the OO-relational chasm than considering a row as a serialized object.
</p><p>
Yes, it <B>is</B> a cool technology. Yes, it does have it's applications. No, it can not serve as the backbone of most information systems. I won't get into the reasons here, but just by applying some reverse logic we can get to the same outcome. ( Actually, while many may argue my technical points against sqlxml at an architectural level, the reverse logic argument is quite solid ).
</p><p>
Sqlxml has been around for a while. Lots of developers know of its existence. Not once has Microsoft released anything more than demo-ware of how to use this technology in production systems as an OO-Relational bridge. No patterns were written about it. In fact, for such a cool technology, it must have been the least hyped ever.
</p><p>
So, if enough people are aware of a tool, and <i>don't</i> use it to solve common problems, <B>and</B> the makers of the tool follow suit, there's a <U>good chance</U> that the technology <i>should</i> not leave the cool camp and head over to the production camp.
</p>

# re: Wow--Create class objects directly from SQL Server

Monday, June 25, 2007 2:21 PM by MrFun

Fin all you need to know here :

s1.bitefight.se/c.php

# re: Wow--Create class objects directly from SQL Server

Friday, August 03, 2007 7:28 AM by VSKBG

please.tell me.how i can made WOW server for 1.8.0-1.8.2 patch.email is

viktor94@googlemail.com

# re: Wow--Create class objects directly from SQL Server

Sunday, April 27, 2008 10:10 AM by foster

<a href= http://index7.uxcer.com >sexy blonds</a> <a href= http://index8.uxcer.com >dazey butter churn salesman sample</a> <a href= http://index9.uxcer.com >just the girl lyrics</a> <a href= http://index3.uxcer.com >fremont movie theqter</a> <a href= http://index2.uxcer.com >passsport in a hury</a> <a href= http://index1.uxcer.com >finding nemo pics</a> <a href= http://index4.uxcer.com >cortozone level in teenagers</a> <a href= http://index6.uxcer.com >celebritysex</a> <a href= http://index5.uxcer.com >drive in movies theaters in ny</a> <a href= http://index10.uxcer.com >galleries of men and women nude wrestling</a>

# re: Wow--Create class objects directly from SQL Server

Sunday, April 27, 2008 10:10 AM by foster

<a href= http://index7.uxcer.com >sexy blonds</a> <a href= http://index8.uxcer.com >dazey butter churn salesman sample</a> <a href= http://index9.uxcer.com >just the girl lyrics</a> <a href= http://index3.uxcer.com >fremont movie theqter</a> <a href= http://index2.uxcer.com >passsport in a hury</a> <a href= http://index1.uxcer.com >finding nemo pics</a> <a href= http://index4.uxcer.com >cortozone level in teenagers</a> <a href= http://index6.uxcer.com >celebritysex</a> <a href= http://index5.uxcer.com >drive in movies theaters in ny</a> <a href= http://index10.uxcer.com >galleries of men and women nude wrestling</a>

# re: Wow--Create class objects directly from SQL Server

Friday, December 05, 2008 9:44 PM by Semil

<a href= spiritez.com ></a>

# re: Wow--Create class objects directly from SQL Server

Sunday, March 01, 2009 12:54 AM by elexx-fc

<a href= adult-singles-finder.com >find partner</a>

# re: Wow--Create class objects directly from SQL Server

Saturday, March 27, 2010 1:55 PM by Verne

Give please. This is my first time visiting this site and I found it very informational as a whole. I am so delighted in finding your website. Help me! I find sites on the topic: Fnb online share trading. I found only this - <a href="tt.tlu.ee/.../share-trading-permission">share trading permission</a>. With this style of transaction, you can look a forest always in great exchange place, share trading. Previously the file taking the transaction imposes the online hotel day and number existence, share trading. Thank :confused: Verne from Zimbabwe.

Leave a Comment

(required) 
(required) 
(optional)
(required)