Connecting/integrating Oracle to C#

[Salvation]

Salam all!
I am in dire need of your help.
Here is the problem.

We (2 of my friends and i) are working on a project, a sales information system for an organization. My part was planning, analysis and designing. I have designed the EER diagrams, the relational models, use cases, data flow models etc. This phase is complete. Now my friend told me that he does not know how to integrate the oracle datAbase into c#, and honestly neither do I. I know how to connect the database to c# but what I want is that when I install the software into my client's computer it automatically generates all the tables from the oracle in the background without installing the Oracle again into that particular computer(of course that would be stupid).

I would REALLY be thankful to any of you who can help me here. The deadline is really really close and this is seriously a big issue which I did not know of.
Please Help! and thanks.
@Shyber @staticPointer [MENTION=10790]Em0s[/MENTION]

 

[staticPointer]

Salam all!
I am in dire need of your help.
Here is the problem.

We (2 of my friends and i) are working on a project, a sales information system for an organization. My part was planning, analysis and designing. I have designed the EER diagrams, the relational models, use cases, data flow models etc. This phase is complete. Now my friend told me that he does not know how to integrate the oracle datAbase into c#, and honestly neither do I. I know how to connect the database to c# but what I want is that when I install the software into my client's computer it automatically generates all the tables from the oracle in the background without installing the Oracle again into that particular computer(of course that would be stupid).

I would REALLY be thankful to any of you who can help me here. The deadline is really really close and this is seriously a big issue which I did not know of.
Please Help! and thanks.
@Shyber @staticPointer @Em0s

dear, i understand ur problems. u have designed the phases i.e. eer, r/s models and UC, thek hy wo !!!!!
now the problem is about connectivity to db from c# to oracle, right???

 

[Shyber]

Is there an obligation to use Oracle? How big is the scope of the project? Is it a website?
For portable deployments, I suggest using MySQL or MS Access.

If you're in Karachi, you may visit me with your laptop and I'll set you right up.

 

[Salvation]

Is there an obligation to use Oracle? How big is the scope of the project? Is it a website?
For portable deployments, I suggest using MySQL or MS Access.

If you're in Karachi, you may visit me with your laptop and I'll set you right up.

The scope of the project is not too big actually. And no it is not a website. There will be no multiple users/computers connected to a server a database either.
The client is an agency, a cold drinks distributor to be exact. He needs to keep record of each and everything (on daily basis). for example, vans, salesmen, orders, stock, defectives, empty bottles, monthly profit, weekly profit and similar other stuff.

Using Oracle is not an obligation. I chose it because I had studied it quite well when I was in 3rd semester. I can do it in MySQL as well. I will need to spend some hours studying the syntax first (I have never used MYSQL). The Problem is that I am not left with much time, hardly a week.

I am from Abbottabad, the other end of the country. No coming to Karachi.
Right now I am designing the interface in C# plus all the required functions. Connecting it to the database is not an issue. What I want is that I do not have to install the Oracle database client on my client's computer.

To keep it simple, right now while designing the forms in C# I have to run the Oracle database client in the background in order to transfer the data to it from C#. of course now i will not do the same with my client. I will not install Oracle on his computer and I cannot bound hime to run Oracle in the background in order to store his data. What i want is that when I install the software in his computer it automatically generates all the tables in the background and which are connected to the interface.

I hope you're understanding.

 

[Salvation]

dear, i understand ur problems. u have designed the phases i.e. eer, r/s models and UC, thek hy wo !!!!!
now the problem is about connectivity to db from c# to oracle, right???

yes permanent connectivity after software installation. Please read the details above and answer if know. thanks

 

[Shyber]

The scope of the project is not too big actually. And no it is not a website. There will be no multiple users/computers connected to a server a database either.
The client is an agency, a cold drinks distributor to be exact. He needs to keep record of each and everything (on daily basis). for example, vans, salesmen, orders, stock, defectives, empty bottles, monthly profit, weekly profit and similar other stuff.

Using Oracle is not an obligation. I chose it because I had studied it quite well when I was in 3rd semester. I can do it in MySQL as well. I will need to spend some hours studying the syntax first (I have never used MYSQL). The Problem is that I am not left with much time, hardly a week.

I am from Abbottabad, the other end of the country. No coming to Karachi.
Right now I am designing the interface in C# plus all the required functions. Connecting it to the database is not an issue. What I want is that I do not have to install the Oracle database client on my client's computer.

To keep it simple, right now while designing the forms in C# I have to run the Oracle database client in the background in order to transfer the data to it from C#. of course now i will not do the same with my client. I will not install Oracle on his computer and I cannot bound hime to run Oracle in the background in order to store his data. What i want is that when I install the software in his computer it automatically generates all the tables in the background and which are connected to the interface.

I hope you're understanding.

I understand your problem.
You're trying to hunt a mosquito with a bazooka here.

Ditch Oracle. Use MS Access. It's a simple DB file on HDD and C# based .NET desktop apps can read/write directly to a file on HDD. You need not to run complex DB systems/services.
Access has a very user friendly GUI for tables design etc and uses SQL just like Oracle DB. Just export all your tables and relations from Oracle as an SQL query, run it on Access and you'll have your DB file ready in Access. Then simply use this file for all storage actions in your app and simply put it on the PC where you deploy your app.

 

[hotgamerft]

In order to connect c# to oracle, you will be needing Oracle Data Provider for .NET

Used it myself works just fine, the link contains the basic information and all. Should be enough to get you started.

 

[Salvation]

I understand your problem.
You're trying to hunt a mosquito with a bazooka here.

Ditch Oracle. Use MS Access. It's a simple DB file on HDD and C# based .NET desktop apps can read/write directly to a file on HDD. You need not to run complex DB systems/services.
Access has a very user friendly GUI for tables design etc and uses SQL just like Oracle DB. Just export all your tables and relations from Oracle as an SQL query, run it on Access and you'll have your DB file ready in Access. Then simply use this file for all storage actions in your app and simply put it on the PC where you deploy your app.

Thanks a lot. I will start working on it now I will post if I see any other hurdle.

- - - Updated - - -

In order to connect c# to oracle, you will be needing Oracle Data Provider for .NET

Used it myself works just fine, the link contains the basic information and all. Should be enough to get you started.

Thanks a lot for this! Studying it right now.

 

[umairhaque]

Boss if you still have problems than Msg me. i can solve your problem by remotely.

 

[Azimiester]

there are ADO.NET classes through which you can easily connect to an oracle database and manipulate it using its classes ..

use Oracleconnection class to connect to a database ..
Oraclecommand object to put in your quries/stored procedure..

 

[Salvation]

project completed and delivered
had to ditch Oracle unfortunately. I designed the database in Access because it was a lot more simpler and the client wasn't using a server giving access to multiple users.

But I am still open to suggestions if anyone can tell me how to create a database in oracle and integrate it with C# or any other language such that I do not have to install the Oracle software itself in the client machine?

Or is that even possible? Like maybe Oracle can only be used for creating server databases?

 

[kooldj]

.net aur sql zindabad. lamby lamby kaam, hogay ab asan!

 

[abdulrahim]

project completed and delivered
had to ditch Oracle unfortunately. I designed the database in Access because it was a lot more simpler and the client wasn't using a server giving access to multiple users.

But I am still open to suggestions if anyone can tell me how to create a database in oracle and integrate it with C# or any other language such that I do not have to install the Oracle software itself in the client machine?

Or is that even possible? Like maybe Oracle can only be used for creating server databases?

It is possible but not advisable if you want to make seperate Database server use Ms SQL Server with .net. It will be alot more faster and efficient.

 

[Major Aly]

Creating databases using SQL Server Management Studio Express

Visual C# .NET: Create tables in a SQL Server Express Database

How to: Save Dataset Changes to a Database

sql dataadapter parameter | DaniWeb

--------------

I connected a SQL server with C# for my Final Year Project, and the above links helped me.

 

[umar]

it's a bit late to advice but sqlite3 would have been even more simpler to use SQLite Home Page