Re: Embedded SQL in C#

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

<<There are all sorts of database factory patterns that would enable
multiple database support>>
That is true. I looked at NHibernate, which is a factory. It looks
like it has a lot of merit but there seems to be a substantial up-front
effort to make it work, and lots of lines of code.

Embedded SQL can be verified at compile-time. Do you know of any way
to catch an SQL error at compile time in C#? An example is invalid
column name, invalid table name, or SQL syntax error.

PowerBuilder provides an option to report SQL errors at compile time.
It is extremely helpful to find an error at compile time rather than at
runtime. And, it is very nice to be able to validate all SQL in the
entire application in a compile, if desired. This compile-time error
detection, plus the easy ability to copy and paste the SQL for unit
testing, saves a lot of time when developing an application. Also, it
makes for far fewer lines of code, which are much easier to understand.

Victor Reinhart

.

Relevant Pages

  • Data Access Software Architecture?
    ... applicaitons that are heavy on database manipulation. ... related tables and has its own set of stored procedures. ... would have compile time checking of your SQL. ... I sometimes find not being able to see SQL in my code a little ...
    (microsoft.public.dotnet.framework)
  • Data Access Architecture w/ OOP
    ... applicaitons that are heavy on database manipulation. ... related tables and has its own set of stored procedures. ... would have compile time checking of your SQL. ... I sometimes find not being able to see SQL in my code a little ...
    (comp.object)
  • Data Access Layer Architecture?
    ... applicaitons that are heavy on database manipulation. ... related tables and has its own set of stored procedures. ... would have compile time checking of your SQL. ... I sometimes find not being able to see SQL in my code a little ...
    (comp.lang.java.programmer)
  • Re: Embedded SQL in C#
    ... > multiple database support>> ... > Embedded SQL can be verified at compile-time. ... > PowerBuilder provides an option to report SQL errors at compile time. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Oracle JDBC error
    ... I know there's no invalid names in the insert because I can insert ... I'm using oracle's ojbdc14 jdbc driver and Java 1.6. ... If so, post the SQL INSERT ... Oracle, when accessed via JDBC and similar libraries, processes the ...
    (comp.databases.oracle.server)