3 ms·

One problem with Entity Framework is lack of alternative (not MS Sql Server) database support. We are a Microsoft shop. However recently we've had to integrat

One problem with Entity Framework is lack of alternative (not MS Sql Server) database support. We are a Microsoft shop. However recently we've had to integrate with Oracle and now MySql. Oracle has just released beta support for EF: http://www.oracle.com/technetwork/topics/dotnet/downloads/oracleefbeta-302521.html http://www.oracle.com/technetwork/topics/dotnet/downloads/or... We have been Using Cool Storage (http://viciproject.com/wiki/projects/coolstorage/home http://viciproject.com/wiki/projects/coolstorage/home) for quite some time. Honestly, It's the best ORM I've ever used. It stays out of your way and it doesn't surprise you. It's very easy to set up. I'm surprised it hasn't gained more popularity. Cool Storage is the reason I haven't kept up on EF and the changes to ADO.NET. Bonus: it works with Oracle and other non MSFT databases. Bonus++: It's open source.

vyrotek 16y ago
Very, uh, cool. I'll have to check out Cool Storage. How does it handle eager loading One-to-Many relationships? Such as, an Order has multiple Products and my query selects 3 Orders for a customer. Will those Products come pre-populated? A big issue I have with LinqToSQL and EF is the double/triple/n db dipping that can occur when trying to fill a complex entity.
- pragmatic 16y ago
  I believe by default they are all loaded in one step. You can use the [Lazy] attribute if you want to lazy load instead.
pragmatic 16y ago
A new release is coming soon: CoolStorage 1.5 will be released sometime in April and it will support the following platforms out of the box: - .NET 3.5 / SQL Server - .NET 3.5/ Oracle - .NET 3.5 / MySql - .NET 3.5 / Sqlite - .NET 3.5 / MS Acess - .NET 3.5 / VistaDB - MonoTouch / Sqlite - MonoDroid / Sqlite - Windows Phone 7 / Sqlite - Mono / Sqlite http://forum.viciproject.com/viewtopic.php?f=8&t=368 http://forum.viciproject.com/viewtopic.php?f=8&t=368

vyrotek 16y ago

Very, uh, cool. I'll have to check out Cool Storage. How does it handle eager loading One-to-Many relationships? Such as, an Order has multiple Products and my query selects 3 Orders for a customer. Will those Products come pre-populated? A big issue I have with LinqToSQL and EF is the double/triple/n db dipping that can occur when trying to fill a complex entity.

pragmatic 16y ago
I believe by default they are all loaded in one step. You can use the [Lazy] attribute if you want to lazy load instead.

pragmatic 16y ago

A new release is coming soon: CoolStorage 1.5 will be released sometime in April and it will support the following platforms out of the box: - .NET 3.5 / SQL Server - .NET 3.5/ Oracle - .NET 3.5 / MySql - .NET 3.5 / Sqlite - .NET 3.5 / MS Acess - .NET 3.5 / VistaDB - MonoTouch / Sqlite - MonoDroid / Sqlite - Windows Phone 7 / Sqlite - Mono / Sqlite http://forum.viciproject.com/viewtopic.php?f=8&t=368 http://forum.viciproject.com/viewtopic.php?f=8&t=368