Component that helps generating sql code
- From: "Peter Laan" <plnews2000@xxxxxxxx>
- Date: Fri, 8 Jul 2005 17:02:26 +0200
I've been spending a few hours writing a component that helps generate
simple sql queries. But if I can come up with the idea, it's probably stupid
or someone has already done it. So does anyone know of a component that does
something like this (or is it a stupid idea)? It's no supposed to be able to
handle all queries, just make life a bit simpler 95% of the time. The code
would look something like this (SqlSelect is the helper class):
SqlSelect sql = new SqlSelect("Customers");
sql.AddSelectColumn("fname");
sql.AddSelectColumn("lname");
sql.AddWhereParameter("fname", "john");
sql.AddWhereParameter("lname", "smith");
SqlCommand cmd = sql.GetCommand(conn);
I then had another idea. Why not make a program that extracts all user table
data from the database and creates source code with constants for all table
and column names. Is this another stupid idea? The generated source code
would be something like this:
namespace Appname.DBNames
{
public class Customers
{
public const string a_TableName = "Customers";
public const string c_fname = "fname";
public const string c_id = "id";
public const string c_lname = "lname";
}
}
One class for each table. The 'c_' is there in case a column name collides
with a reserved name. 'a_' is used to get the table name first in
intellisense.
You would get great help from intellisense by typing
DBNames.Customers.c_lname. But if you don't use a component like above to
help generate the sql code, the code might get ugly. The sql string would
quickly get very long.
Any comments?
Peter
.
- Follow-Ups:
- Re: Component that helps generating sql code
- From: Cor Ligthert [MVP]
- Re: Component that helps generating sql code
- Prev by Date: Re: Connection Timeout
- Next by Date: Re: Component that helps generating sql code
- Previous by thread: Running a job manually
- Next by thread: Re: Component that helps generating sql code
- Index(es):
Relevant Pages
|
