I am testing Prism, using the Oxygene command line compiler from RemObjects (it's free). I'm using it since my Delpi Rad Studio 10 is Delphi Only.  Prism is Object Pascal, but it has a few differences, so for now I'm testing using just the command line compiler.  .Net libraries work well enough from most vendors, and I would like to test the ElevateDB .Net libraries, so ....

Could you list a programmatic example of building up a connection to a server using code ? And maybe creating a simple table if you have time.  A delphi example will be just fine.

I've installed the DAC, and I'm running the 32bit unicode server.

I am an old VCL hand, sorry !!!

Thank you.

Mark,

<< I am testing Prism, using the Oxygene command line compiler from
RemObjects (it's free). I'm using it since my Delpi Rad Studio 10 is Delphi
Only.  Prism is Object Pascal, but it has a few differences, so for now I'm
testing using just the command line compiler.  .Net libraries work well
enough from most vendors, and I would like to test the ElevateDB .Net
libraries, so ....

Could you list a programmatic example of building up a connection to a
server using code ? And maybe creating a simple table if you have time.  A
delphi example will be just fine. >>

The only thing different with the EDB data provider, over any other data
provider, is the connection string.  Therefore, any XXXConnection,
XXXCommand example for Prism will work fine with EDB by just replacing the
XXX with EDB.

I don't have a Delphi example of the .NET data provider handy, but here is
how you would do it in C#:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Elevate.ElevateDB.Data;

namespace ElevateDBCreateTable
{
   public partial class Form1 : Form
   {
       public Form1()
       {
           InitializeComponent();
       }

       private void button1_Click(object sender, EventArgs e)
       {

           EDBConnection DataConnection = new
EDBConnection(@"TYPE=LOCAL;CONFIGPATH=C:\Unicode;DATABASE=ADOUnicodeTest;UID=Administrator;PWD=EDBDefault");

           DataConnection.Open();

           EDBCommand DataCommand = new EDBCommand();
           DataCommand.Connection = DataConnection;
           DataCommand.CommandText = "CREATE TABLE TestTable (Test
INTEGER)";
           DataCommand.ExecuteNonQuery();

       }
   }
}

Basically, you're looking at just changing {} to begin..end, double-quotes
to single-quotes, and = assignments to := assignments (apart from the
auto-generated event handler code, etc.).

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim thank you so much.

I use the c# command line compiler also.