Okay, assume I have a .Net application written with C#. I have the .Net
interface thingy. The .Net application is just starting up, and decides
it wants to create a new Session, and within that Session a new
database and some new tables in that. The location of each of those is
unknown at compile time. Is that all possible? There would be no EDB
Manager installed to assist, it has to do everything from scratch.


--

Matthew Jones

Matthew,

<< Okay, assume I have a .Net application written with C#. I have the .Net interface thingy. The .Net application is just starting up, and decides it wants to create a new Session, and within that Session a new database and some new tables in that. The location of each of those is unknown at compile time. Is that all possible? There would be no EDB Manager installed to assist, it has to do everything from scratch. >>

Sure, you would do it just like you would in Delphi.  For example, the following code will create a database on the fly:

       private void button1_Click(object sender, EventArgs e)
       {
           EDBConnection DataConnection = new EDBConnection(@"NAME=Test;DESCRIPTION=Test Connection;TYPE=LOCAL;CONFIGPATH=C:\MyApp;DATABASE=Configuration;UID=Administrator;PWD=EDBDefault");

           DataConnection.Open();

           EDBCommand DataCommand = new EDBCommand();

           DataCommand.Connection = DataConnection;

           // Create the database

           DataCommand.CommandText = @"CREATE DATABASE MyDatabase PATH 'c:\myapp\mydata'";
           DataCommand.ExecuteNonQuery();

           DataConnection.ChangeDatabase("MyDatabase");

           DataConnection.Close();
       }

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Sure, you would do it just like you would in Delphi.  For example,
> the following code will create a database on the fly:

Many thanks.


--

Matthew Jones