SQL Server and postgresql support XML data type Now I can store xml data in regular text field, but I lose benefits of indexing and xquery usage inside sql server. Is there any plans for XML support?

asked Jan 17 '11 at 07:28

pil0t's gravatar image

pil0t
207575763


One Answer:

Hello pil0t,

There is no any exact plan for xml support, and this is why (recently, I've answered almost the same for multi tenancy support feature):

After 4.4 is released we're going to take a survey on the future of DataObjects.Net. I mean, with the help of its users we'll try to choose the most awaited features, so we could implement them first, and so on. For instance, if the "XXX" feature get noticeable weight, we'll give it high priority.

Concerning database xml datatype support we also should care about correct datatype mapping. For example, which native .NET type should be mapped to xml database type? How modifications of xml documents should be tracked? Should some extension for writing LINQ queries over xml type be provided? And so on.

In case you've got any ideas on the subject, please, share with us. This will definitely help.

answered Jan 17 '11 at 09:39

Dmitri%20Maximov's gravatar image

Dmitri Maximov
22111211

  1. native .net type to map is XObject
  2. modifications - like text field (may be something else)
  3. extensions to write LINQ queries over xml is highly demanded: value ( to write something like SELECT xCol.value( 'data((/doc//section[@num = 3]/title)[1])', 'nvarchar(max)') FROM docs)

query/exist/nodes is less intresting I mean (http://msdn.microsoft.com/en-us/library/ms345117(v=sql.90).aspx Methods on XML Data Type)

(Jan 17 '11 at 09:51) pil0t pil0t's gravatar image

Thanks a lot!

Will launch a feature voting service soon.

(Jan 17 '11 at 09:54) Dmitri Maximov Dmitri%20Maximov's gravatar image
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

×52
×1

Asked: Jan 17 '11 at 07:28

Seen: 5,110 times

Last updated: Jan 17 '11 at 09:54

powered by OSQA