Nhibernate and ObservableLists

[Dunnerholl]

Hi, I hope some people are still reading this.

Is there any elegant solution to use Observable anythings with Nhibernate?

Or put to other words, what is a common practice of binding Lists retrieved from Nhibernate to the UI?

I dont want to make any kind of wrapper classes, just to get this working. Its cumbersome work.

Cheers

Dunner

[Ephemeral]

Are we talking about something for DOL's core? Or something that you can write with any toolkit to observe changes as they happen, cause I thought most of the ORM stuff does it for you (ADO I think does, but not sure?), either way it'll probably end up cumbersome for you.

[Dunnerholl]

No a Dol core but a WPF editor tool for the database.

[Dunnerholl]

Found a way, it's called uNhAddIns.WPF.dll which has persistent lists that fire those stupid changed events.

[Graveen]

Good to know ! I never worked with NHibernate. Best i did with mainstream ORM was EF4, but, it was not leading to something serious.

The latest jewels i find were Dapper and his friend PetaPoco. Just don't have any projects to work on that would benefits one of them.

[Ephemeral]

Good now graveen, move DOL to EF or Nhibernate so we can have other DB's besides mysql :p

[Aredhel]

Good now graveen, move DOL to EF or Nhibernate so we can have other DB's besides mysql :p

My project at work (application server) is actually based on EF and speaking from experience, multiple DB provider support isn't as easy as it may seem. Yes, there are different EF providers, but the typical scenario is to target a single DB provider, which might be SQL, MySQL, Oracle etc. To target all of them with the exact same model is not a straightforward task (for example, you need a different SSDL to target Oracle, coming from SQL). But it can be done with some T4 scripting.

[Graveen]

Yop Aredhel !

I got hard time with T4. The generated layouts where crappy, but i had not written the scripts (and really don't want to). I had finally the occasion to work with Petapoco. Not LINQ compliant, but finally, very efficient.

[Aredhel]

Yop Aredhel !

I got hard time with T4. The generated layouts where crappy, but i had not written the scripts (and really don't want to). I had finally the occasion to work with Petapoco. Not LINQ compliant, but finally, very efficient.

Hiho Grav

Well, the idea is to have one master EDMX (MS SQL in my case) and then have T4 scripts perform some XSLT transformations (for example, Oracle requires all table/column names to be upper case). You'd then switch to alternate providers by referring to a different SSDL in the connection string.

First time I've heard of Petapoco, by the looks of it you're still tied to a single DB provider with that one (explicit SQL, no E-SQL layer).

[Dinberg]

Nice to see both Dunner and Aredhel still kicking about

[Aredhel]

Nice to see both Dunner and Aredhel still kicking about

And Din too - hiya

[Dinberg]

Pah! As if I ever leave

[Dunnerholl]

is this thread really from this year?