473,387 Members | 1,318 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

PreparedStatements?

Hi

in Java I would more often than not use a PreparedStatement for database
access (if I wasn't using an abstraction layer like Hibernate for example).

Is there an equivalent construction to PreparedStatements in C#? (Or what is
the best accepted method in the .NET/C# world for communicating with a
database?)

Thanks,
Peter
Nov 17 '05 #1
1 4261
Have only the most basic knowledge of Hybernate, which seems to be a ORM
tool the .NET framework doesn't seem to have any production version of this
type of tool.As for the most common way to access databases from .NET code
would be to use ADO.NET, a collection of components that comes with the .NET
framework that access to databases easy.

If you have the framework check out the System.Data.* namespaces.

This site has good links to ADO.NET resources
http://www.datadirect.com/developer/...inks/index.ssp

Good place to start
http://msdn.microsoft.com/library/de...withadonet.asp

Hope this helps.
Cordell Lawrence
Teleios Systems Ltd.

"Peter Kirk" <pk@alpha-solutions.dk> wrote in message
news:%2*****************@TK2MSFTNGP14.phx.gbl...
Hi

in Java I would more often than not use a PreparedStatement for database
access (if I wasn't using an abstraction layer like Hibernate for example).
Is there an equivalent construction to PreparedStatements in C#? (Or what is the best accepted method in the .NET/C# world for communicating with a
database?)

Thanks,
Peter

Nov 17 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Robert Brown | last post by:
Is there a way to use PreparedStatements (or bind variables) with SQL statements that have a variable number of arguments. For example, I have an array of IDs for employees of a certain type and I...
1
by: Ranga | last post by:
Hi, I am getting the following error when i am using query no in my sql statement and compiling the stored proc. I am doing this on Unic UDB DB2. Please let me know if i am mising something here....
2
by: Antony Paul | last post by:
Hi all, What are the characters which requires an escape sequence when used in the query. I am writing an application using JDBC. rgds Antony Paul ---------------------------(end of...
1
by: tom.eeraerts | last post by:
Hello, I have a problem migrating an application from v5r2 to v5r3. The problem is with the prepared statements. To see what the problem is, i extracted a small piece of code and debugged the...
2
by: technocrat | last post by:
HOW CAN THIS BE DONE IN JAVA??? THIS IS POSITIONED UPDATE EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM EMPLOYEE FOR UPDATE OF JOB; EXEC SQL OPEN C1;
3
by: bennett.matthew | last post by:
Hello, Is there a good way to make PreparedStatements with a variable number of parameters? My queries look something like this: SET @rowid := null; SELECT * FROM ( SELECT
14
by: abctech | last post by:
Helo experts, I'm working on my first ever web application and I have some basic questions related to servlets if I may, I have 5-6 Java statements and preparedstatements in my servlet to...
6
by: redashley40 | last post by:
This is my first attempt in SQL and PreparedStatement I have add the PreparedStatement and I'm not to sure if I'm doing it correctly. When I do a test run on Choose 1 ,or 2 I get this error. Error...
6
by: =?ISO-8859-1?Q?Tim_B=FCthe?= | last post by:
Hi, we are building a Java webapplication using JSF, running on websphere, querying a DB2 9 on Suse Enterprise 10. The app uses JDBC and PreparedStatements only (aka dynamic SQL). Every night,...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
Oralloy
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,...
0
jinu1996
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...
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.