Use sql queries in XML vb.net

Question

1.00/5 (2 votes)

See more:

I just started using XML as a database with .Net not long, I am faced with the task of Selecting nodes based on criteria by passing SQL queries and keywords as (LIKE, CONTAIN,SUM etc). XML Database Format

HTML

<institutions>
<institution type="university" abbrv="absu" name="Abia State University (absu)" />
  <institution type="university" abbrv="atbu" name="Abubakar Tafawa Balewa University (atbu)" />
  <institution type="university" abbrv="achievers" name="Achievers University (achievers)" />
<institutions>

I want to be able to get institutions using LIKE, SUM and other keywords eg. Get Institution where name like '%Abia%' I dont want to use dataset before filtering, I need a direct approach to this. Please help me with some good working examples or books. thanks

Posted 26-Oct-15 9:35am

Prince Tegaton

Add a Solution

Comments

Richard Deeming 26-Oct-15 15:51pm

XML is not a database. If you need to support SQL queries, then use a database.

The closest you'll get with an XML file is LINQ to XML[^], which will let you write LINQ queries against an XML document.

Maciej Los 26-Oct-15 16:17pm

This is an answer!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2015-10-26T10:42:00

Quote:
I just started using XML as a database

Your first mistake is XML is NOT a database. It is an eXtensible Markup Language used to format data for transmission or temporary storage. It has no query capabilities at all.

Quote:
XML Database Format

Again, there's no such thing.

If you want query capability, you'll have to use either some wrapper around the XML data that implements this, such as "LINQ to XML" (Google it) or use an actual database engine and store your data in there, like SQL Server Local Db or SQL Server Express.