I haven't worked on a .NET project for a while (more than a year). Before I've never used an ORM for a .NET application. What are some of your takes on this? Does using one make sense? Which ones should I consider trying? ...
Has anyone tried the ActiveRecord Intro Sample with C# 3.5? I somehow have the feeling that the sample is completely wrong or just out of date. The XML configuration is just plain wrong: <add key="connection.connection_string" value="xxx" /> should be : <add key="hibernate.connection.connection_string" value="xxx" /> (if I understa...
I am trying to leverage ORM given the following requirements: 1) Using .NET Framework (latest Framework is okay) 2) Must be able to use Sybase, Oracle, MSSQL interchangeably 3) The schema is mostly static, BUT there are dynamic parts. I am somewhat familiar with SubSonic and NHibernate, but not deeply. I get the nagging feeling that th...
I work with a lot of web applications that are driven by databases of varying complexity on the backend. Typically, there's an ORM layer separate from the business and presentation logic. This makes unit-testing the business logic fairly straightforward; things can be implemented in discrete modules and any data needed for the test can b...
I'm curious if anyone has done any performance comparisons with any or all of the main players in the .NET ORM space. Specifically I'm interested in comparisons between the following: Linq to SQL NHibernate LLBL Gen Entity Framework Though it seems people don't really consider Linq to SQL a true ORM, I am still including it in this l...
I'm creating an ORM in PHP, and I've got a class 'ORM' which basically creates an object corresponding to a database table (I'm aiming for similar to/same functionality as an ActiveRecord pattern.) ORM itself extends 'Database', which sets up the database connection. So, I can call: $c = new Customer(); $c->name = 'John Smith'; $c->sav...
Hi everyone! I'm looking for opinions on the DBCook framework as a declarative wrapper for SQLAlchemy.. Has anyone used it? Thanks for your time! ...
I am about to start a project for a potentially heavily accessed ASPNET MVC application and I was thinking to use Subsonic for my DAL. I have some concern about the ability of Subsonic to handle thousands of concurrent requests. Can anyone give me some examples of popular web sites using Subsonic? Also if you have any suggestion regardi...
Is anyone using or has anyone evaluated OPF3 as an ORM (.NET)? How does it stack up against EntitySpaces or Subsonic? One thing about OPF3 I like in my evaluation so far is that it is very easy to customize. Since it binds database fields to object members using attributes, you do not need to use any code generation tool. This also mea...
I have a working LINQ to SQL model. I want to be able to use the same model but with a connection to a DataSet object, instead of SQL Server. I need to be able to query the model, modify fields, as well as do insert and delete operations. Is there an easy way to accomplish this? I noticed another question mentions a similar scenario,...
I was considering creating a separate SQLite database for certain apps on a Django project. However, I did not want to use direct SQLite access if possible. Django-style ORM access to these database would be ideal. Is this possible? Thank you. ...
What should happen when I call $user->get_email_address()? Option 1: Pull the email address from the database on demand public function get_email_address() { if (!$this->email_address) { $this->read_from_database('email_address'); } return $this->email_address; } Option 2: Pull the email address (and the other User a...
I've been trying to encode a relational algebra in Scala (which to my knowlege has one of the most advanced type systems) and just don't seem to find a way to get where I want. As I'm not that experienced with the academic field of programming language design I don't really know what feature to look for. So what language features would...
That's the question. Give only one reason you think why have OODB failed or why many systems nowadays still use relational databases. ...
I'm very impressed with my initial tests with db4o. However, i'm wondering just how many enterprise class websites are out there powered by db4o, i couldn't see any on the main website? I can't see any reason why db4o should not be used. There appears to be decent enough support for transactions and ways to handle concurrency for examp...
Have you ever used CSLA and if so what are yout thoughts? I am starting a new contract for a company that uses CSLA and NHibernate and wanted some opinions or insights into the framework. ...
The expressiveness of the query languages (QL) provided with ORMs can be very powerful. Unfortunately, once you have a fleet of complex queries, and then some puzzling schema or data problem arises, it is very difficult to enlist the DBA help that you need? Here they are, part of the team that is evolving the database, yet they can't rea...
Is there a way to define a column (primary key) as uuid in sqlalchemy if using postgresql? ...
Is it possible to make hibernate do "the right thing" for some value of "right" in this situation? from ClassA a, ClassB b where a.prop = b.prop The thing is that prop is a UserType with different representation in the joined tables. In table A it is represented as an integer and in table B it is represented as a char. So the eq test ...
I'm looking for an ORM (Object-Relational Mapper) for PHP. I want something simple that I can get started with quickly. I'm used to ActiveRecord in Rails, but I don't need a full framework. My partner knows PHP, but is not really a programmer, and learning a framework would take more time than the project. Thanks, Craig ...