Ramana, Thanks for the info, I'll take a look into it.
> (1) Can the third party do CRUD operations on the virtual tables and some how your runtime will translate it to the Physical table? Yes, this is the basic requirement, and much more, requirement says that we need to be able to support persistenting of object graph with mixed native objects (mapped from physical table) and custom objects(mapped from our storage model) > (2) Can the third party developers write Queries (Linq querires or TSql) on the virtual tables? Yes, we first think that if we can solve this hibernate mapping problem with these custom objects, they can write HQL. (3) Assuming that the third party would like to run adhoc queries on their virtual table, what tool would they use to run queries? LinqPad? We have a query builder for our native objects now, which basically generates HQL on native objects, and this is why we are investigating that if Hibernate can be extended to custom objects, so that all feature available now canl be automatically extended to custom objects On Wed, Mar 25, 2009 at 3:07 PM, Ramana Kumar <[email protected]>wrote: > Hi Kelven > Your requirement sounds similar to the Mapping a Conceptual Model to a > Storage Schema <http://msdn.microsoft.com/en-us/library/bb399232.aspx> where > you map your third party custom objects to the storage using the Entity > framework. > In NHibernate/Fluent-NHibernate, you may want to look at the "Fluent > NHibernate semantic model" that Paul Batum (http://www.paulbatum.com/) is > working on. > > When you say custom virtual tables, I am not sure what you are referring > to. For example > (1) Can the third party do CRUD operations on the virtual tables and some > how your runtime will translate it to the Physical table? > (2) Can the third party developers write Queries (Linq querires or TSql) on > the virtual tables? > (3) Assuming that the third party would like to run adhoc queries on their > virtual table, what tool would they use to run queries? LinqPad? > It does look like a sizable project to do with NHibernate... Just my > $.0.02 > > HTH > Ramana > > On Wed, Mar 25, 2009 at 3:34 PM, Kelven Yang <[email protected]> wrote: > >> Ayende, >> >> Thanks very much for such a quick response. >> >> >> We are using NHibernate (.NET). I'm now investigating if we can >> "customize" Hibernate code, making it utlize our meta-info database, and >> finish ORM mapping for these custom objects. I'm not sure if this is too >> ambitious? >> >> Kelven >> >> >> >> >> On Wed, Mar 25, 2009 at 1:30 PM, Ayende Rahien <[email protected]> wrote: >> >>> Are you talking about .NET or Java? >>> >>> >>> On Wed, Mar 25, 2009 at 4:21 PM, kelveny <[email protected]> wrote: >>> >>>> >>>> We've developed a storage model which can allow virtual custom tables >>>> to be collapsed to a fix number of physical tables, the idea of this >>>> is to allow third-party developers to develop and deploy new features >>>> with custom objects on top of our runtime system. >>>> >>>> We've been heavily used Hibernate for our native objects, with this >>>> new feature requirement, we would like to extend the same model to >>>> third-party developers, which means, to extend Hibernate ORM power >>>> across native objects and custom objects. >>>> >>>> From Hibernate perspective, make its mapping layer work on these >>>> custom object, how ambitious is it, or if not, what is the best >>>> approach to do so? >>>> >>> >>> >> >
