LINQ(DLINQ,XLINQ) - XML - Sql Server

Greetings,

i want to be able to use linq new technology with sql server.

the senario i am not able to do so far is as follow:

1- i program with linq
2- be able to generate and manipulate xml files
3- all this xml files are stored in Sqlserver

for those who are not familiar with linq
http://msdn.microsoft.com/data/ref/linq/

u can still help me by mentioning orignal ways of working with xml files
through sqlserver as the database.

thanx

Sharing makes All the Difference

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com
0
9/4/2006 4:35:42 PM
dotnet.xml 7266 articles. 0 followers. Follow

3 Replies
603 Views

Similar Articles

[PageSpeed] 50

can anyone help please ??! any ideas ??!

Sharing makes All the Difference

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com
0
9/5/2006 6:09:34 AM
> 1- i program with linq

Have you installed the May 2006 CTP of LINQ?  If not, go to:

    http://www.linqdev.com

In the top right corner of the page is a section labeled "LINQ Latest 
Release".  Click on the link to go to the Microsoft page to download the 
latest version.

You will see a lot of LINQ information there at LINQDev.com.  I hope it helps.

> 2- be able to generate and manipulate xml files

Once you have installed the May 2006 LINQ CTP, you will have a "LINQ 
Preview" menu option in your start/All Programs menu.  In the LINQ Preview 
menu you should see toward the bottom XLinq info such as an overview as well 
as hands-on labs for both C# and VB.



"Dave Johnson" wrote:

> Greetings,
> 
> i want to be able to use linq new technology with sql server.
> 
> the senario i am not able to do so far is as follow:
> 
> 1- i program with linq
> 2- be able to generate and manipulate xml files
> 3- all this xml files are stored in Sqlserver
> 
> for those who are not familiar with linq
> http://msdn.microsoft.com/data/ref/linq/
> 
> u can still help me by mentioning orignal ways of working with xml files
> through sqlserver as the database.
> 
> thanx
> 
> Sharing makes All the Difference
> 
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com
> 
0
JoeRattz (4)
9/6/2006 2:32:02 PM
> thanks already done tht, i was just asking to see if anyone have
> guidance to this typical pattern from previous experiance

Oh, I guess I misunderstood your question.  I thought you had said that you 
were unable to program at all with LINQ.


> so for noone seems to have much experiance in LINQ

Well, LINQ is still very new, so I suspect you will not find too many people 
with practical experience with it.  But, I wouldn't go as far as you stated.  
In case you are not aware, there is a LINQ specific forum at MSDN.  Again, if 
you go to http://www.linqdev.com and look in the Crucial LINQ Links, you will 
find a link to the offical LINQ forums.  There are many people there really 
digging into LINQ.

Good luck.

"Dave Johnson" wrote:

> thanks already done tht, i was just asking to see if anyone have
> guidance to this typical pattern from previous experiance.. so for noone
> seems to have much experiance in LINQ. so i will keep working and post
> any good updates..
> 
> thanks again
> 
> Sharing makes All the Difference
> 
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com
> 
0
JoeRattz (4)
9/7/2006 1:23:01 AM
Reply:

Similar Artilces:

Populating objects from XML file
Hello, I have an XML file that contains parent / child relations between objects. e.g. There is a Manager who can have one to many employees and these employees can have one to many phone numbers. I would like to know the best way to retrieve this information from the XML file and store into business objects. I have the following idea which would work 1) Load the XML file into a DataSet (After validating against a schema) and then use the relationships defined in the schema to match objects between datatables Is there a better / way to do this? Thanks Adam Adam w...

PPP server?
Probably the wrong newsgroup, but I'm used to this one and I hope someone will point me in the right direction ... In the days of NT there used to be a thingy called RAS or RRAS (depending on version) which provided a PPP "server" (yes I know PPP is peer-to-peer and doesn't have a concept of "server"). This could be configured to answer the phone, hand out an IP address to the dial-in client, and then route its traffic through onto the internet. I now have a requirement to do something similar, but the PPP client won't be an external device dialling in, ...

Accessing the companyweb from the server
I am not able to open up the companyweb from the server console logged in as administrator. Why is that and what can I do to correct this problem? This is a multi-part message in MIME format. ------=_NextPart_000_0027_01CAF831.BFAA1080 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: quoted-printable http://blogs.technet.com/sbs/archive/2009/04/17/authentication-issues-acc= essing-companyweb-from-the-server-itself-after-963027.aspx --=20 Cris Hanna [SBS - MVP] (since 1997) Co-Contributor, Windows Small Business Server 2008 Unleashed http://ww...

XML Validation: required attributes
Hello All, I was trying to validate an XML document against a XSD which works fine. Then I tried to put in a version attribute on the root element and set it to a fixed value of '1.0' in the schema. Guess what? The validator completely ignores the attribute inspite of the fact that I have set the attribute to be required and to have a fixed value of '1.0'. Any ideas why that could be happening. Any help is appreciated. Uttara Either you didn't do what you thought you did or the validator has a problem. Which validator did you use and what are your schema/instance? ...

Sql to return items in promo
Hi, Somone much more inteligent than me once told me a sql to run in HQ which would return all items which have a Qty discount/ promotion applied to them.. I cant find it - would someone be able to remind me? Thanks v much Phil Hi Philip see if this returns what you are looking for.... select i.itemlookupcode, i.description, qd.description from item i inner join quantitydiscount qd on i.quantitydiscountid = qd.id "Philip Gass" wrote: > Hi, > > Somone much more inteligent than me once told me a sql to run in HQ which > would return all items which have a Qt...

How is fastest way to construct an XML node then a bunch of slow xquery
How is fastest way to construct an XML node then a bunch of slow xquery modify statements? This SQL Server 2005 logic is rather slow to simply add a new item to an xml document. Any way to do this all in one statement and faster for creating a new node without having to re-select to set the attribute values? set @currentItems.modify('insert <Item></Item> as first into (/Items/ParentItem[(@id=sql:variable("@parentItemID"))])[1]') set @currentItems.modify('insert (attribute id {sql:variable("@itemID")}, attribute length {sql:variable("@metadataL...

OWA HTTP Error 500.13 Server Busy
We've been getting error 500.13 Server Busy on our Exchange Server since Friday night. Nothing changed in our setup (Windows 2003 Exchange 2003). We don't have any restrictions set in IIS to limit the number of connections. I'm not sure what's causing this. Email is working properly from Outlook 2003, we just cannot connect from OWA. Any advice would be greatly appreciated. E ...

SQL Server 2008 Extended Events
I am using SQL Server 2008 Std SP1 on a Windows 2008 std 64-bit server. I am trying to understand and use Extended Events. I have created a session that is to monitor tempdb usage when ever there is a physical page write. I want to capture the query that is causing this action. Below is my session defintion: CREATE EVENT SESSION Monitor_tempdb_usage ON SERVER ADD EVENT sqlserver.physical_page_write ( ACTION (sqlserver.nt_username, sqlserver.sql_text, sqlserver.client_hostname, sqlos.task_time, sqlserver.username, sqlserver.session_id) WHERE sqlserver.database_id ...

XML getting the namespace
Hi, I'm working on a ASP.NET component with one requirement being to catch Web Service exceptions. I've managed to get it working using the following code XmlDocument doc = new XmlDocument(); doc.LoadXml(se.Detail.OuterXml); XmlNamespaceManager nsManager = new XmlNamespaceManager(doc.NameTable); nsManager.AddNamespace("prefix", "http://localhost/site/test/ webservice.asmx"); string errorMessage = doc.DocumentElement.SelectSingleNode("// prefix:ErrorMessage", nsManager).InnerText; Response.Write("Error message:" + errorMessage); The issue i...

parse string with xml contents
Hi I have a string with the following contents: "<TR align=right ID=G><TD align=left><A HREF="/comun/fichaemp/fichavalor.asp?isin=ES0111845014"><IMG SRC="/images/arr-up9.gif" BORDER=0> ABERTIS SE.A</A></TD><TD>19,96</TD><TD ID=V>0,15</TD><TD>19,96</TD><TD>19,83</TD><TD>1.060.525</TD><TD>21.115,00</TD><TD align=center>27/06/2005</TD><TD align=center>17:35</TD></TR>" What would be the simplest way to parse it, and keep only &qu...

Exchange server using Office 2003 and Vista
I'm trying to connect to my corportate email through Outlook 2003 using exchange server. The instructions that were provided to me are for PCs running Windows XP and Outlook 2003. I can't complete the setup because I don't have some of the icons listed in the instructions. I think it is because of my OS. I am running: Windows Vista Home Premium (64 Bit) Office 2003 Professional Is there a way to setup up Office 2003 to connect using exchange server in the Vista Home Premium or is this ANOTHER feature not available? Any suggestions would be greatly appreciated. ...

Project Portfolio Server 2007
Hi. I want to install Project Portfolio Server 2007 on a server Win 2003 R2 + SP1, SQL Server 2005, windows sharepoint (All in standalone box). I got the following error... Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 10005 Date: 6/17/2007 Time: 4:00:13 AM User: SERVER\Administrator Computer: SERVER Description: Product: Microsoft Office Project Portfolio Server 2007 -- Error 26204. Error -2147217913: failed to execute SQL string, error detail: Se termin=F3 la instrucci=F3n., SQL key: DB_PPSAccountData_Upgrade_12_Integrated SQL string: begin ...

Moving server .. what are the best practice steps?
Hello, I'm a sys admin who for first time will be moving our exchange box from our colocation to our own physical network. So my manager has asked if i have a solution, agenda and plan. I of course dont because I havent done this before and cant answer a few of his questions. Maybe a seasoned sys admin on the list here can help me. Here is a list of what I do have or doing so far. - The IP at our network is already determined and i will execute a change of the MX record a day before the move for propogation reasons. - I will be imaging the box with Acronis True Image w/ Universal Hardw...

OLE Error in Outlook after SQL Server 7 installed
After installing SQL Server 7 (aka 2000) on a users machine, user is getting "OLE registration error. Please run setup." when Word is the email editor. Remove Word as the email editor and it works fine. HELP! (and please don't say reinstall office) ...

setting up a secure SMTP server
Hello everyone Just wanted to get an idea what be most secure method for configuring our SMTP gateway server. In our environment all smtp servers are exchange 2003 that are members of a single forest/domain . Currently our SMTP gateway (exchange 2003) is a muti home server with 2 separate nic cards, each have been assigned to separate virtual server for inbound and outbound connections to the internet. We have created two SMTP connectors and under the local bridge head server we added the corresponding virtual server .For example, for connections out to the internet we added the outbo...

XML with two tables
HI The XML below has two tables.They are Category and Products. I need to get the Products when i select a Category for eg:- when i mention "CAR" the i need to get "maruthi","santro" and "ford". The relation between the two tables is "Category_Product". I'm getting all the products. Can any one Help me. <?xml version="1.0" encoding="utf-8" ?> <Catalog xmlns="http://tempuri.org/Products.xsd"> <Category> <Name>Car </Name> <Product> <title>Maruthi</title&...

How do I include Nulls in my xml
I want to create a dataset, send it to a folder on the clients hard drive using XML through my VB.Net application. However, the resulting dataset does not include columns with nulls. How do I write my code to include Nulls? Dim daSection As New SqlClient.SqlDataAdapter(Sqlcm2) daSection.SelectCommand = New SqlCommand("Select * from vwGetSurveyData", Cn) daSection.Fill(dsSectionData, "SurveyData") daSection.FillSchema(dsSectionData, SchemaType.Mapped, "SurveyData") Cn.Close() saveFiledialog.InitialDirectory = "c:\SSSFiles" saveFiledialog.Filte...

Do XML Attributes HURT VB.Net DATAVIEWS????
I don't know how else to put this, because I'm new to VB.net but here goes... I'm trying to create a DataView from an XML file. Some of the nodes in the XML file happen to have Attributes, others do not. Lets use the following as an example: <MyXml> <ANode> <ANodeWithNoAttribute>Hello</ANodeWithNoAttribute> <ANodeWhichHasAnAttribute MyAttribute="MyAttributeValue">World. </ANodeWhichHasAnAttribute> </ANode> </MyXml> Now, imagine I'm creating a DataSet based on the above XML document called "MyDataSe...

Exchange server in new domain
Hi, I am hoping someone can help me. I work at a co. that merged with another and they migrated what they thought were all the mailboxes to the new co. ( new domain) That worked fine but now the old company's exchange server is here and the realized they forgot the public folders as well as some mailboxes. Is there a way to retrieve these mailboxes off the old exchange server and either get them into pst files or import them into their exchange store? Thanks Use Exmerge to extract the mailboxes. -- Bharat Suneja MCSE, MCT www.zenprise.com blog: www.suneja.com/blog --------------------...

Unable to Connect to Server
I have just installed Office 2004 Student and teacher edition on Tiger, and I am unable to connect to the server to get any updates or use Entourage. I am connecting to the internet via my universities wireless service and I have set up the proxy settings in the network configure in Systen Preferences and i can browse the web fine using safari. Is there something similar I have to do in office itself? I have configured to HTTP proxy in messenger and that works fine. How do I get it to connect? Thanks for any assistance ...

Exchange server 2003 deleted, HELP!!!
Hi, I started with an Exchange 2003 (Windows 2003 server in an Windows 2003 AD) server in our organisation. Later we added a Exchange 2003 cluster. Everything went just fine until... I first moved all mailboxes from the old server to the cluster and deleted the old server with the Enterprise Manager. I know a very bold and stupid action, expecially if you haven't checked things properly before the action. I forgot to replicate the Public Folders to the new Exchange cluster. Anyway, is there a way to get the old Exchange server back in the Active Directory? SillySys ...

Cannot connect to two exchangr server simultaneously
At our office we have an exchange server, and on my home server I have an exchange server as well for my family mail. My home server is available remotely but... I cannot add that account to my profile. Outlook simply does not allow me to add it. How can I solve this? What 's the best way to have access to both servers? In article <OWLXPjNpEHA.2588@TK2MSFTNGP12.phx.gbl>, jan@van- veldhuizen.nl says... > At our office we have an exchange server, and on my home server I have an > exchange server as well for my family mail. > My home server is available remotely but... I ca...

Increase storage for rules on the Exchange Server
I need to know how to increase the amount of storage allocated to a user for storing their rules. I am getting errors that not all the rules can be activated because the user has run out of said space to store them on the exchange server. Where in exchange can I go to alter this setting. -Ron Merrifield You can't - Exchange 5.5/2000/2003 only supports 32K per folder. http://support.microsoft.com/default.aspx?scid=kb;en-us;147298 [Public Info] This will change in Exchange 12. http://www.msexchange.org/ExchangeNews/March-2005-32K-Storage-Limit-E12.html -- Bharat Suneja MCSE, MCT w...

problem with syncro with two exchange 2000 servers
Hi, I got two servers in the same domain and the same organisation, but for some raison the syncro with the public folder does not seem to be ok, I've got all the directory but, did'nt get any of the post message in the second server ex: if I post a messase with attachement in it, if I am a user on the first exchange server np, but if I am on the second I am not able to see the post with the attachement on it Hope that it is clear. I really need help on this. Thank you very muc ...

How to move development in c# from test to production server?
Hello! I'm MS CRM newbie, but please answer my question. I made some buttons and some other development in VS 2003 (used c#) on my test server and my question is how to move all that to my production server? Thanx in advance. What kind of application is it that you want to deploy? A callout, win32 app or customized forms? Anything else? If your question is about how to target your code to a CRM server other than your development server, the answer probably is here: http://www.stunnware.com/crm2/topic.aspx?id=SDKFAQ -- Michael H�hne, Microsoft Dynamics CRM MVP Web: http://www.stu...