Database Question

Hot Topic

How do i iconify apps in c#?
Simulation Run Time
How prevent code from firing
Need help setting audio tracks in iHD
CallBack from a WIN 32 C++ dll
String Testing
Show Console
Database Connection String
Writing data to a text box - Question
Build problems?

Visual C#

Are strings any easier in the new C#?
C# 2.0 doesn't allow me to use System.Void?
Converting Small endian to Big Endian using C#(long value)
Problem with WDS Filter
How to create a new instance of the template type?
Bounded lists
Context Menu
foreach loop stays in infinite loop when an exception occurs.
file.exists does not check file on a network
Dynamically moving controls

Database Question

Hell All,

I am creating a program that will be used by about 20 people or so. It is a test case managment system, what I want to do is have everyone connect to a central database on a server somewhere on the network and be able to edit , update, create, save test cases. What I am unsure of is, do I need to write software on the database server to handle transaction, etc, or can i just connect to the database from the program on the users desktops, and load the data both ways from there. I am new to database programming. Also is there a way to write generic database commands, so any database, like MySQL, PostgreSQL, Oracle can be used on the server and I wont need to change the code on the client side. Thanks for your help. Also if you know of any good C# database programming links, I dont mind reading.

Answer this question

Database Question

  • do-wah-ditty

    Hey,

    Each database usually has its own syntax, so compatibility will not be a likely option, especially when you want to take advantage of the database-specific features.

    I use transactions in my stored procedures, which do the insert/update/delete, then the ADO.NET components that call it just do the call (or can be all in web/windows app).

    Brian

  • Shaking Stevens

    Thanks for the reply, when you do the call from the ADO.Net components, you just send the info that needs to be updated to a stored procedure you created in the database app itself ( I.E MySQL) and that will run the SQL needed to update the database. Is this correct Thanks again for your help. Also does the ADO.NET API's support sending the info over the network, or do I have to create a socket and all that stuff manually. I am guessing my connect statement will connect to the database when I give it the I.P and then make a call to the stored procedure with the data to be updated.

  • lxiao

    Hey,

    I have business components that I pass variables to, which the data layer passes those variable values to the stored procedure. Over the network capabilities, you should look at .NET remoting or web services for a distributed architecture.

  • Chad W Stoker

    You can use stored procedures to interact with data in ADO.NET, but it is much more common to generate the appropriate SQL at the time of the update/insert/delete. If you use the appropriate command builder for your provider (i.e. OleDb, Sql, Oracle), it will make sure that the syntax is correct for the provider you are using, so you dont have to worry about cross-provider compaitability.

  • Database Question
Answer this question