Marc,
Not question specific, but can I suggest something? Based on the
series of questions (over the last 2 months or so?) it seems that to
meet your intended design, you are currently having to fight the
system at almost every stage. Perhaps this simply isn't the right way
to do it?
The questions I posted represent the issues I encountered.
Currently I have application prototype which allows to define properties in
runtime, uses virtual grid for editing List<Entity> data sources. It seems
to be possible to use .NET.
I'm trying to find the limits of .NET using probing to get max from it.
Java has more ready to use open-source components for ERP line OfBiz
framework and even full application, ADempiere. Unfortunately I havent seen
any open-source component in .NET for ERP like OfBiz in Java.
It shouldn't be this hard! And no, unfortunately I don't
have any magic advice: "do it this way and all shall be grand"...
My first prototype was using NHibernate/Castle ActiveRecord .
I ported it to DbLinq. Currently it seems this was right way. It seems that
Linq is better than NHibernate:
is has better documented, I can get more support, I must debug only driver
code (some thousands lines) which is a much less that NHiberante/Castle
(half million lines).
Now, *possibly* LINQ-to-Entities will (when released) make a viable
alternative to DbLinq (which I believe is part of the issue relating
to property-order/reflection), but hard to tell at this stage...
My customers use Linux/NetBSD for 15% .. 50% of servers. I use PostgreSQL
dbms.
LINQ-to-Entities seems to support only MS SQL.
It's architecture does not allow to create drivers for other databases like
Linq.
It even has specialized SQL language dialect which gets converted to MS SQL
server on the fly.
I read the LINQ-to-Entites FAQ but did'nt understand how to use it in my
application.
So I'm trying to create my own entity layer based on Linq.
But there's a lot of things here (esp. the runtime code creation/
inheritance) that are going to make this very hard to support, and (I
would hazard) quite brittle.
My prototype uses runtime code generation. I havent tested this part
extensively but it seems to be possible, 5000 lines of c# code seems to be
created from existing assembly and compiled fast in my 1.7 Ghz notebook,
custom columns can be retrieved using Linq.
If inheritance is implemented generated code is reduced to less than 500
lines in most cases.
Linq-SQL supports inherited entity class IFAIK.
George will try to replace parameterized contructors usage in DbLinq code
tonight so I expect DbLinq should support it also.
Andrus.