We have column list, from table name, where conditions informaion.using this info we want SQL query in .NET

Question

1.00/5 (1 vote)

See more:

We have column list,From table Name,where conditions Informaion.Using this info we want DB query in .net which will used for all database like SQL,Oracle.

Column List - A,B,C
From Table - D
Where condiiotn- A='a'

What I have tried:

I have not got a perfect solutions .All the query builders required database Information like username password .So i m not interested to provides all the DB data.

Posted 15-Jan-18 19:53pm

Member 13624874

Updated 15-Jan-18 20:52pm

Jörgen Andersson

Add a Solution

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)

OriginalGriff · Answer 1 · 2018-01-15T20:52:00

The query is simple:

SQL

SELECT A, B, C FROM D WHERE A = 'a';

But the "required database Information like username password .So i m not interested to provides all the DB data." is necessary.
You can't just access a database of any type randomly: you need to tell the system which database engine to use (by using the correct set of classes: SqlConnection, SqlCommand, ... for SQL Server, MySqlConnection, MySqlCommand, ... for MySql, OleDbConnection, OleDbCommand, ... for ODBC sources like Access, Excel, ..., OracleConnection, OracleCommand, ... for Oracle.
And y-u need to provide the XXXConnection object instance with a Connection String to tell it which server (if appropriate) and which database on the server you need to access. And to prevent people who shouldn't have access to your data getting in, that connection string will probably need user name and password (for live systems, development get by with Window Authentication).

You can't get away from that, and more than you can get away from the need to have your car car with you in order to drive to the shops: it's the "connection string" that lets you drive a specific vehicle. A different "connection string" in the form of a different key is needed to drive my car.