Hi,
I am intersted in trying to reduce the cost of C# development, by
reducing the number of lines of code. In my opinion, as a business
developer, the biggest opportunity to reduce the number of lines of
code is in database access.
My reality is that I use relational databases a lot. Other constructs,
such as flat files, Web Services, arrays, etc I don't use very much.
My data is stored on relational databases. I think that's pretty
common, nowadays.
I have been using ADO.NET and was wondering about the future.
Will C# support truly embedded SQL in the future? For example, in
PowerBuilder, since 1992, you could code as follows:
Long ll_count
String ls_last_name
SELECT Count(*), max(last_name) INTO :ll_count, :ls_last_name USING
TXN1;
IF TXN1.SQLCODE<>0 THEN ...
In C#, it seems to take many more lines of code to do the same thing.
Further, in PowerBuilder, the above statement works for any relational
database. All you have to do is change the connection parameters.
It seems that in C#, you have to contend with named parameters for SQL
Server and Oracle, vs. positional parameters for ODBC and OLE-DB.
Further, you have to explicitly create every single parameter in C#,
while in the example above, the parameters are created for you, using
datatypes which match the datatypes you use. That is a lot simpler.
Also, in C#, you are forced to use multiple TRY-CATCH constructs after
each SQL statement is executed. And, the exceptions which you catch
are different for different databases. That's an awful lot of code.
PowerBuilder has TRY-CATCH too, but it is generally not used for
relational database access.
And, let's talk cursors. In PowerBuilder, COBOL, and a few other
languages, such as PL*SQL, you can explicitly declare, open, fetch, and
close cursors. Wouldn't it be great if you could do that in C#?
Cursors give you low-level control. They are simple. And, if you
fetch too much data, you can stop.
In PowerBuilder and COBOL, you can even 'fetch in batches'. This means
that instead of getting one row at a time from the database, you
actually grab, say, 1000 rows at a time. Fetching in batches can
improve runtimes by 20 to 1, if your database is over a Wide-Area
Network, or by 4 to 1 if it is on a Local Area Network, in my
experience.
I think Embedded SQL makes sense because maybe, just maybe, it would
not become obsolete, as have a few other technologies (RDO, DAO, ADO,
etc).
Also, I think Embedded SQL is inherently much simpler than all the
above.
For example, a severe performance problem in a classic ASP application
was impacting one of my customers. The ASP app used ADO. I have read
many books about ADO, but not a one of them explained to me how a
"keyset" worked. It turns out that a keyset reads *all* the keys from
your SQL table, and puts them into memory. Well, when your table has 3
million rows, this becomes untenable. But then, how many people know
about this fact?
The reality is that RDO, DAO, ADO and ADO.NET all do things "behind the
scenes" which make performance tuning difficult. You have to capture
the actual SQL they send to the database first, then tune.
I don't want to need ADO to do that for me. Wouldn't you rather just
have real embedded SQL?
Opinions?
VictorReinhart
Dec 29 '05
25 11145
<<stored procedures are validated at the time of creation or change. >>
It is true that in C#, there is no validation of SQL when it is
compiled. In PowerBuilder, however, there is. You will get a compiler
warning for any embedded SQL which has a database syntax error, for
example, incorrect column or table name. This can also be turned off.
This is another advantage of embedded SQL. The same applies for stored
procedure calls.
If your C# code which calls a stored procedure has the wrong number or
type of arguments, do you get a warning at compile time?
<<Personally, I'd hate to be the one to hunt down and fix
who-knows-how-many embedded SQL statements in a large project (the size
of those to which you refer in another post), should there ever be a
need to alter the database design. >>
Well, in PowerBuilder, if you compile your application, all SQL errors
in embedded SQL show up as warnings. True, not all my SQL is embedded
-- some is dynamic and most is in datawindows, but the point is that it
is possible for the C# language to be more tightly integrated with
relational databases than it is.
In my opinion, using embedded SQL, given the syntax checking at compile
time, it would actually be much easier to maintain than to maintain
stored procedures. For example, to unit test my embedded SQL, just
copy and paste into SQL*Plus and test it. How do you test your stored
procedures?
VictorReinhart <vi************ **@phs.com> wrote: In my opinion, using embedded SQL, given the syntax checking at compile time, it would actually be much easier to maintain than to maintain stored procedures. For example, to unit test my embedded SQL, just copy and paste into SQL*Plus and test it. How do you test your stored procedures?
I unit test mine with DbUnit and JUnit. That way they're still
automated, unlike cutting and pasting with SQL*Plus...
--
Jon Skeet - <sk***@pobox.co m> http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too
<<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
VictorReinhart <vi************ **@phs.com> wrote: <<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.
Does that mean you can only use absolutely standard SQL? What if you
want to use SQL which is T-SQL or P/L SQL specific? The language (and
the compiler) would have to have detailed knowledge of all the
databases you want to use. That sounds like a bad idea to me.
To be honest, the idea of a general-purpose *language* knowing about
SQL directly doesn't sound very nice to me - any more than I like the
idea of the language itself knowing about, say, XML or URLs.
--
Jon Skeet - <sk***@pobox.co m> http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too
The compilation would be caught at the stored procedure level.
Again, your design architecture preference is much different
than most developers and best practices suggest.
Your whole argument pretty much falls on deaf ears...
--
Robbe Morris - 2004/2005 Microsoft MVP C# http://www.eggheadcafe.com/forums/merit.asp
"VictorReinhart " <vi************ **@phs.com> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. . <<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
Seems like the solution is to use PowerBuilder if it provides the
functionality you want/need.
--
Derek Davis dd******@gmail. com
"VictorReinhart " <vi************ **@phs.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com... <<stored procedures are validated at the time of creation or change. >> It is true that in C#, there is no validation of SQL when it is compiled. In PowerBuilder, however, there is. You will get a compiler warning for any embedded SQL which has a database syntax error, for example, incorrect column or table name. This can also be turned off. This is another advantage of embedded SQL. The same applies for stored procedure calls.
If your C# code which calls a stored procedure has the wrong number or type of arguments, do you get a warning at compile time?
<<Personally, I'd hate to be the one to hunt down and fix who-knows-how-many embedded SQL statements in a large project (the size of those to which you refer in another post), should there ever be a need to alter the database design. >>
Well, in PowerBuilder, if you compile your application, all SQL errors in embedded SQL show up as warnings. True, not all my SQL is embedded -- some is dynamic and most is in datawindows, but the point is that it is possible for the C# language to be more tightly integrated with relational databases than it is.
In my opinion, using embedded SQL, given the syntax checking at compile time, it would actually be much easier to maintain than to maintain stored procedures. For example, to unit test my embedded SQL, just copy and paste into SQL*Plus and test it. How do you test your stored procedures? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jean-David Beyer |
last post by:
I have some programs running on Red Hat Linux 7.3 working with IBM DB2
V6.1 (with all the FixPacks) on my old machine.
I have just installed IBM DB2 V8.1 on this (new) machine running Red Hat
Enterplise Linux 3 ES, and applied FixPack fp5_mi00069.tar to it. After
creating an instance, starting the database, creating a database, and
entering the table definitions, all of which seems to work OK, I entered a
tiny 8-row table and can do...
|
by: Mark Yudkin |
last post by:
The documentation is unclear (at least to me) on the permissibility of
accessing DB2 (8.1.5) concurrently on and from Windows 2000 / XP / 2003,
with separate transactions scope, from separate threads of a multithreaded
program using embedded SQL. Since the threads do not need to share
transaction scopes, the sqleAttachToCtx family of APIs do not seem to be
necessary.
<quote>
In the default implementation of threaded applications against...
|
by: Colleyville Alan |
last post by:
I have been working on an Access app that takes info from a file and writes
it to a spreadsheet on a form, simultaneously saving the spreadsheet to
Excel. I got the idea that the same concept could work in reverse, i.e. we
have a cost model written in Excel that calculates the profitability of
customer accounts based on several inputs and they need to be updated at
least once per year. These cost models sit on lots of people's hard...
|
by: Nick White [MSFT] |
last post by:
Hello fellow Microsoft Windows Mobile and Embedded enthusiasts:
I invite you to peruse the list below of upcoming technical chats and
Webcasts offered by the Windows Mobile and Embedded Devices Group.
For the full list of upcoming Windows Mobile and Embedded chats, to review
archived chat sessions, or to request a reminder for a chat, visit
http://msdn.microsoft.com/embedded/community/community/chats/. Also, the
Windows Mobile and...
|
by: Jeff Bowden |
last post by:
For ease of configuration and other reasons, I would like for my
single-user GUI app to be able to use postgresql in-process as a library
accessing a database created in the users home directory. I think I
could possibly get what I want by launching a captive copy of postmaster
with appropriate args but it seems conceptually cleaner to not have a
seperate process at all. Has anyone tried to do anything like this?
I've looked at sqlite...
| |
by: Alex Vinokur |
last post by:
Are there any restrictions/problems for use of C++ STL in development
in embedded systems?
In particular:
* Does STL require too much space/memory?
* Is 'implementation of STL algorithms/methods' reenterable/reentrant?
* What is the cost to provide continuity of vectors in memory?
Any other problems?
--
Alex Vinokur
|
by: YellowFin Announcements |
last post by:
Whitepaper: "Yellowfin Reporting" enables Embedded Business
Intelligence
--------------------------------------------------------------------------------
Embedded reports are a standard requirement of most applications. But
users are increasingly demanding more sophisticated reporting from
applications - seeking such features as custom report design, ad hoc
report creation and analytics. Developers that want to embed business...
|
by: leeanngriego |
last post by:
I have a client who has asked me to find him some solid up and coming
embedded engineers. 2 to 3 years expereince with Embedded Linux,
VxWorks, Nucleus or any other RTOS who has working in L2/L3 networking.
The object is to bring them on board and train in SAN/NAS switching, as
long as they are solid C, Unix and Embedded programmers that have the
work ethic and talent to be very good, he will train whatever else is
necessary.
See...
|
by: =?ISO-8859-1?Q?Tom=E1s_=D3_h=C9ilidhe?= |
last post by:
There are a few guarantees I exploit in the C Standard. For instance,
I might write
(unsigned)-1
to get the maximum value for an unsigned integer.
Also, I might rely on things such as:
memset(data,-1,sizeof data)
|
by: =?ISO-8859-1?Q?Tom=E1s_=D3_h=C9ilidhe?= |
last post by:
Let's say we had a simple function for returning the amount of days in
a month:
unsigned DaysInMonth(unsigned const month)
{
switch (month)
{
case 8:
case 3:
case 5:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |