Hi I have just won 1 Telerik Premium Collection for .NET Developer with subscription (lucky me!) and was wondering whether the OpenAccess ORM is worth learning? Has anyone thrown away their open source variant and are now using the Telerik ORM tools instead? Are there any benefits from using the Telerik ORM tools instead of an open sou...
I was reading about a feature of an ORM called lazy loading, which, it said, means that larger columns are only loaded when the application actually needs them. How would an ORM decide what a "large column" is - would this be, for example, a blob column that can contain a lot of data compared to, say, an unsigned integer column? And when...
It is the common case when domain model is changed during project development. If db schema is generated from domain model, then the following problem appears. When I change model, I need to change schema also. I am searching for the ORM which can do such changes automatically (or, semi-automatically). At least, the ORM must support the...
I have a dev server with several virtual hosts on it. Each one needs to be able to run the command: propel-gen ./ creole That script executes some php that reverse-engineers the database... BUT the php it executes needs to be included to do so. There is no include_path set in the php.ini because it would be global to all virtual hosts...
I'm exploring the offerings of an ORM (focusing on NHibernate, considering all options) and am convinced that using one could be a great benefit for some of our projects--however I'm having a hard time picturing just how it would play in our system. My understanding is that an ORM is ideally used to glue together a database and business...
Recently, I have become increasingly familiar with Django. I have a new project that I am working on that will be using Python for a desktop application. Is it possible to use the Django ORM in a desktop application? Or should I just go with something like SQLAlchemy? ...
I've gone back and forth on this problem and can't seem to figure out the best way to do this. Here's the situation: Access database (3rd party product) with data I need in it, from a good number of tables (18 tables) Ideally, need to try to get records into strongly-typed objects somehow so I can query around with LINQ LINQ to SQL cl...
Is there a tool out there that I can point at a Java DTO (Data Transfer Object) and it generates a corresponding Flex/AS Domain Object? Vise-Versa? I'm using BlazeDS for my DataService over an AMF line. Thanks. ...
in SubSonic 3, if i use SimpleRepository, can i ask it to generate forkey as well include "one to many", "one to one" and "many to many" is there any sample code i can have a look at???? what i see from its demo, is only for one table, not dealing with relationship ..if it cannot deal with relationship...i won`t go into it and use it...
Working on a project where I have more or less carte blanche to modify the database schema and object model (nice position to be in. (c:) Suppose I have a trivial inheritance tree like: class Parent { public int ID { get; set; } } class Child : Parent { // some fields } Is it better to have a database schema where the child ...
Let's say I have a User model. Would I put methods on the model itself, or as a template so I can access it from the user table object? In other words, which is more preferable: $u=new User(); $u->register($username, $password, $email); or $userTable = Doctrine::getTable('User'); $userTable->register($username, $password, $email); ...
I have a complex, 3NF database being provided to me for a particular project. I would like to avoid using a class-per-table domain design. Rather, I would like to model my domain objects after how they are used from a conceptual business perspective. The rub is how to properly persist this information. I know I can go the ADO route, ...
How does ORM work? Are objects serialized into BLOBs? In Java, is JDO still the way to go for this? What else is available? Seems like there was a lot of talk of EJB, direct object serialization, and JDO. ...
I have a table in database which has some columns like year,name and also 12 columns (m1,m2,...,m12) representing months. I would like to map this table into one class using NHibernate, ideally, these 12 mapped columns would look like: _mappedMonths[] = new double[12]; Has anyone a solution for this ? ...
I'm starting on a new scientific project which has a lot of data (millions of entries) I'd like to store in an easily and quickly accessible format. I've come across a number of different potential options, but I'm not sure how to pick amongst them. My data can probably just be stored as a dictionary, or potentially a dictionary of dicti...
This PostgreSQL query solves my problem, but I'm not sure how to put it in Django ORM. SELECT DISTINCT ON (to_email) * FROM (SELECT * FROM invitation_invitation ORDER BY date_invited DESC) AS sub From a list of items, I want all distinct rows for "to_email" column, and where to_email is duplicate, it should select the latest ( date_in...
I'm working on a .NET application using Silverlight on the client side. Now I've come to the point where I want to throw out my static dummy data on the server side and add a database instead. For the database I'd love to use one of them ORM's where I can simply tag my model classes and the database tables are built for me. I did some ...
I'm attempting to map an object model for "Promotions"; i.e., a customer enters a promo code during signup. Different promo codes might have different types of "benefits", meaning what we are giving to the customer. For example: promo code XYZ123 will give the customer free minutes in his or her account, while a different promo code w...
Possibly a dumb question but I have a number of entities all inheriting from a base entity. The base entity does not have a table in the database. Each entity has its own table and the table definition is exactly the same. Extremely simplified example of the code is below. public abstract class BaseEntity { public virtual string som...
Currently i am using sql encryption and would like to continue using it through Linq. I have all my CRUD stored proc's wired up to the table in order to handle the encryption/decryption on the backend. Problem is my database model see's a field type of varbinary(max) which is used for the sql encryption storage. The retrieval sp for t...