ODX.NET - Distributed ORM Framework

Source code checked in

odx — Sat, 29 Mar 2008 07:25:16 GMT

NEW POST: The show must go on...

johndupreez — Tue, 12 Feb 2008 08:16:05 GMT

Hi

I have been using various versions of Microsoft Basic for over 23 years now, from Microsoft Extended Color Basic on an old 16KB Radio Shack coco, up to the latest VB.NET versions. An interest of mine has been RAD (Rapid application development ) tools, such as Object Relational Mapping tools and Object Control Mapping tools. I have found ODX to be the single most useful RAD tool yet encountered.

Microsoft's existing RAD attempts (being DataSet focused) fail dismally in an Enterprise level Multi-Tier environment where the core focus should be on building Business Layer Classes and not DataSets. This is where I have found ODX to be so powerful becuase the DataSet handling is performed seamlessly in the background, and the developer can get on with the job of building business rules in classes.

There seemed to be a lot of initial activity on this project, with work done almost every day, but I am sad to that the last sourse check in was about 2 months ago. ODX, are you taking a well deserved holiday, or focussing on something else now?

I don't really use the remoting, but use ODX on a server with ASP.NET as the front end with the Middle-Tier Business Layers built into DLL's talking to a SQL 2005 database via ODX.

Please keep up the good work....
John

NEW POST: Save in SQL 2005

RonyMan — Wed, 30 Jan 2008 09:32:04 GMT

Hi,

I'm trying to use the ODX, but I'm facing some problems with the save.
I have a table in a SQL Server 2005 database with an Identity field. (which never can be updated).
Now I created the table Class (as shown in examples) and I can get the data from the database. No problem.
I use following code:

string conString = ConfigurationManager.ConnectionStrings"DefaultBusinessConnectionString".ToString();
DbDataProvider provider = new DbDataProvider(System.Data.SqlClient.SqlClientFactory.Instance, conString);
s = new Session(provider);
s.RegisterAssembly(Assembly.GetExecutingAssembly());
s.Prepare();

Then on my form, i have a datagridview which is binded as followed:
dataGridView1.DataSource = s.All<ImportAccount>();

No problem so far.
But now I change some fields, not the identity field and want to save this to the database:
s.Save(SaveMode.Complete);

Then I receive an error from SQL Server that it is not possible to update the Identity field.

I know that, but how can I save my changes to database ?????
I have tried the different save modes, but it does not work.

Source code checked in

odx — Sat, 01 Dec 2007 14:08:04 GMT

CREATED ISSUE: Upgrading database : null reference

TBPrince — Thu, 29 Nov 2007 12:11:30 GMT

Hello,

when I try to upgrade database and a table gets added, a null reference error gets generated. The problem probably lies in ODX trying to enumerate constraints of old table to upgrade it but no old tables are present for a newly added one. I solved this error by using this code in DbDataProvider.cs (line #502):

foreach (Constraint c in dt.Constraints)
if (old_dt != null) // this is the key !
if (!old_dt.Constraints.Contains(c.ConstraintName))
CreateConstraint(c, conn);

This works for me now.

Hope this helps.

COMMENTED ISSUE: SQL Error while creating tables in a SQL Server 2005 database

TBPrince — Mon, 26 Nov 2007 01:03:59 GMT

Hello,

when creating tables via "PrepareDatabase" method, a SQL Exception gets generated:

"Cannot define PRIMARY KEY constraint on nullable column in table 'x'.
Could not create constraint. See previous errors. "

It looks like that when ODX creates a table it defines ID field as NULLABLE, which is not allowed if such field has to be set as primary key.

Hope this helps.
Comments: ** Comment from web user: TBPrince **

Hello,

this is code I use now. This seems to work for me:

private static void CreateTable(DataTable dt, DbTypeMapper mapper, DbConnection conn)
{
List<string> columns = new List<string>();
DataColumn[] PrimaryKeys = dt.PrimaryKey;
string NotNullModifier = string.Empty;
foreach (DataColumn dc in dt.Columns)
{
NotNullModifier = string.Empty;
foreach (DataColumn KeyCol in PrimaryKeys)
if (KeyCol.Equals(dc))
{
NotNullModifier = " NOT NULL";
}
columns.Add(string.Format("{0} {1}" + NotNullModifier, dc.ColumnName, GetDBType(dc, mapper)));
}
string sql = "CREATE TABLE " + dt.TableName + "(" + string.Join(", ", columns.ToArray()) + ")";

DbCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}

Now tables got properly created. However, PrepareDatabase now fails because it tries to create db_schema.xml file inside default folder, which is set to random locations according to your project.

Hope this helps.

CREATED ISSUE: SQL Error while creating tables in a SQL Server 2005 database

TBPrince — Mon, 26 Nov 2007 00:23:44 GMT

Source code checked in

odx — Tue, 20 Nov 2007 04:28:40 GMT

Source code checked in

odx — Mon, 19 Nov 2007 21:42:29 GMT

Source code checked in

odx — Mon, 19 Nov 2007 20:59:21 GMT

Source code checked in

odx — Thu, 15 Nov 2007 22:15:14 GMT

Predefined proxy class to use remote datasource as web service

Source code checked in

odx — Thu, 15 Nov 2007 21:03:32 GMT

ODX mobile. First draft. Xml data source has been ported. Sql CE is next one.

Source code checked in

odx — Thu, 15 Nov 2007 19:19:04 GMT

Source code checked in

odx — Thu, 15 Nov 2007 18:54:59 GMT

Source code checked in

odx — Thu, 15 Nov 2007 18:46:11 GMT

Source code checked in

odx — Thu, 15 Nov 2007 18:14:39 GMT

Source code checked in

odx — Thu, 15 Nov 2007 18:10:16 GMT

CREATED FEATURE: Parent/Child objects Prefetch

odx — Tue, 13 Nov 2007 06:03:06 GMT

ODX should be configurable for prefetching data. For example, if I select a list of books, I may want to iterate authors then. And I want to load all of them in single request, not one by one at each Author property access.

CLOSED ISSUE: Error when using GUIDs for fields types

odx — Mon, 12 Nov 2007 18:56:15 GMT

Hello,

evaluating your library and first impressions are very good.

I have a problem though: when using a GUID for a field (and hence, as type in Entity definition), BuildDataSet() will fail with exception: "There is no cast defenition!!!". GUIDs are very commonly used so I think it should be fixed.

Keep up the good work!

CLOSED ISSUE: Problem with SQL Compact Edition

odx — Mon, 12 Nov 2007 18:55:09 GMT

Hello,

when trying to connect to a SQL CE database using SqlCeProviderFactory an exception is being generated when using an instruction like this:

[VB.NET]
OLEDBSession.Data = New DbDataProvider( _
OLEDBSession.Schema.Clone(), _
SqlCeProviderFactory.Instance, _
"Data source=testdb.sdf;Encrypt='no'")

Exception test is "SchemaSeparator" and no inner exception are present.