5 Kicks

SQL Server XQuery with LINQ To SQL(chriscavanagh.wordpress.com)

submitted by BobStroggBobStrogg(1033) 1 year, 2 months ago

LINQ To SQL doesn’t provide a way to include Xquery expressions in queries. The simplest solution is to create SQL user-defined functions that perform the Xquery for you and return scalar results. This works pretty well for small databases, but you lose the benefit of SQL Server’s XML indexes. To get around that, we can modify the SQL command text to expand the function calls into raw Xquery expressions.

add a comment |category: |Views: 117

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
flyingkickflyingkick(331) - terry.aneyterry.aney(115) - sekharchandrasekharchandra(0) - aaconnectaaconnect(1)
More who kicked this story...
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?