I know what i want but not sure of the name and required tools so here goes... I have a few different sql tables. I want a tool that will generate an object in my .net project for each table, with each column a property of this object. (i.e. strongly typed, no datatables) I want to be able to call select, insert, update and delete met...
Hi ALL: We have a new django powered project which have a potential heavy-traffic characteristic(means a heavy db interaction). So we need to consider the database scalability in advance. With some researches, the following questions are still not clear to us: coarse-grained: how to specify one db table(a django model) to a specific d...
Hi, I am developing a enterprise software for a big company using Oracle. Major processing unit is planned to be developed in PL/SQL. I am wondered if there is any ORM like Hibernate for Java, but the one for PL/SQL. I have some ideas how to make such a framework using PL/SQL and Orcale system tables, but it is interesting - why no one h...
So I'm working on a CMS that will allow users to "traverse" through database tables. I'm having some trouble implementing it though, and am wondering if anyone has any suggestions. Table: house name (varchar), town (relationship, using the rel table) Table: town name(varchar), state (relationship, using the rel table) Table: state na...
Our current ORM solution uses Data Mappers to represent tables / views in the database which then return a Collection object that can be used to iterate through the retrieved records as Model objects. Between the Data Mapper and Model layers is a Repository layer that handles domain requests to the data mappers and returns the correspond...
Is it necessary for two SQLAlchemy models to inherit from the same instance of declarative_base() if they must participate in the same Session? This is likely to be the case when importing two or more modules that define SQLAlchemy models. from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() class SomeClas...
How can I map a class that contains a HashMap using Fluent NHibernate? ...
Hi. I have 3 tables organization(id, name, and etc) organizationContact(organizationId, contactId, status) contact(id, name, email) How can I make a many to many mapping and use status column from organizationContact? ...
I'm not sure if this is possible in Hibernate but it would be really great if it was :) I've not actually got past the conceptual stage with this but I'll explain as best as I can. I want to make use of Oracle Spatial features to do proximity based searching. Imagine I've got a Location entity which stores a latitude/longitude value. Th...
I have a two classes, Service and Customer, with a many-to-one association from Service to Customer. I want to delete a Customer and any Service that references it. I'm using JPA as the ORM (with Hibernate underneath) attached to a PostgreSQL db. It'd be great if I could define the association in such a way that deleting the Customer wo...
I would like to hold a ref of some other entity using its identifier. The object model which I am working on is huge and related entities hold lot of data. Also few pieces are cyclic in nature and I suspect that holding objects directly will be a problem. So consider following as an example say there are two entities A & B: Class A {...
How can I specify the size of the type used in the following Dictionary mapping: HasMany(x => x.WidgetSettings) .AsMap<string>(idx => idx.Column("SettingKey"), elem => elem.Column("SettingValue")) .Not.LazyLoad() .Table("WidgetSettings"); The mapping defau...
Hello, I'm currently designing a website, using symfony (1.2) with Doctrine as an ORM. I have a Dinner class, a Criteria class, and a Mark class. A Mark is linked with a Dinner and a Criteria, and has private attributes, like DateOfMark, MarkValue, etc. Dinner and Criteria can have many Marks (or none). As I use Doctrine, I defin...
Right now, I'm switching my project over from the classic fluent nhibernate style of manually defining a ClassMap for each domain entity, to having the auto-mapper auto-generate the mappings for me. But I'd like to keep using the classes I've already mapped in the classic style, until I can tweak the automappings to match the old classi...
I'd like to start by apologizing for my unfamiliarity with Hibernate. I'm only recently getting into it and am far from an expert. I have three tables: Contract, Products, and a link table between them to define a many to many relationship. I'm trying to write an HQL query to return all contracts that contain a range of products. Un...
Hello, I need to use a sequence to get a unique value. The production code uses postgres but I would like to access it via Hibernate so that I can test this with HSQLDB. How can I create and read a sequence in Hibernate? ...
Heya, I'm currently trying to get bltoolkit working in my project. I've added the BLToolkit.3 project to my solution and am referencing it appropriately. The code in question is really simple. public List<Account> LoadAccounts() { using (DbManager db = new DbManager("MySql")) { var query = new SqlQue...
How would I go about mapping three classes to one table with fluent NHibernate. A "Type" column should indicate which class should be mapped. Is it even possble? Kristoffer ...
Hi, I am learning ASP.NET MVC now a days and I have found that most of the examples in ASP.NET MVC are with ORM. I don't have any issue in using ORM for my learning and personal project. But at my work we have worked only with ASP.NET web forms and we use stored procedures only. We have data access layer (simple c# classes) as interface ...
Does anyone know of a ORM tool for .Net that will work on a database with no primary keys defined? We are running MS SQL Server 2005 by the way. I cannot change the DB schema and add primary keys - the DB is the of our ERP system and their business logic is aware of what would make a table non-sensical. For example, it would make se...