XML as database
-
Hi, which are the best pratices of using xml as database? can i query it like in sql server? wher linq fits here? links appreciated thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
-
Hi, which are the best pratices of using xml as database? can i query it like in sql server? wher linq fits here? links appreciated thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
Using XML as a database is generally a bad idea because it's a lot slower than using an actual database. LINQ helps a little, but I certainly wouldn't want to write a crapload of code to do it. Not only do you have to load/save the data continuously, you have to worry about rolling back transactions, and other stuff that the database server usually takes care of. Generally, if the data in your XML file exceeds 1mb, and has more than just a few "tables", it's a better idea to use a real database.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001