Hi all, I am looking to obfuscate a data access layer which is written using NHibernate. The problem is, the mappings are done in XML files which are embedded as resources in the class library - which means the mapping are in clear text. Two potential solutions are to use: 1. Nhibernate Mapping attributes (NHMA) to decorat ethe entitie...
I am looking at using an ORM in PHP for the first time. Until now my PHP projects have been fairly small and an ORM seemed like overkill. I really like NHibernate so I was hoping that there is an ORM out there for PHP that works and is configured similarly to NHibernate. If there is one with a fluent interface like Fluent NHibernate tha...
I want to use an Object Relational Mapper (ORM) tool for my ASP.NET application. I have three options: NHibernate, LINQ to SQL, and Subsonic. Which one is fastest? ...
Do you have one gigantic linq to sql DBML or Linq to entities .EDMX file / namespace or many files/namespaces separated logically?? For example in a db schema if you have 3 sub schemas like (Audit and UserMgmt), Human Resource, Sales..would you have them separated? ...
Strings are unbounded, but it seems every normal relational database requires that a column declare its maximum length. This seems to be a rather significant discrepancy and I'm curious how typical ORMs handle this. Using a 'text' column type would theoretically give you much more string-like storage, but as I understand it text columns...
I know that you can generate a database from classes and their mappings using nHibernate, but I can't find any good links to do this the other way around. We have a database that has already been designed, and we are looking at using nHibernate. It would be nice to use a tool to generate the mappings and classes from the database, and ...
I have the following schema: create table statuslookup { statusid int primary key, statusname string unique, description string } create table job { jobid int primary key, jobname string unique, status_id foreign key reference statuslookup(statusid) } The table statuslookup will, of course, be prepopulated during the sche...
Is there an OR/M (object relational mapper) that can be used in Classic ASP? Even a simplified class object would be a great help in handling simple CRUD tasks. Yes I know ASP.NET has many and I use a few of them for ASP.NET sites. However this is a legacy e-commerce site that uses ASP/VBScript and a total rewrite it not a possibility. ...
Hi all, I have to begin a medium-sized project in Java, but I'm not a big fan of ORMs in general so the question is: Should I design the project with an ORM in mind (for later use) or not? The RDBMS is Oracle 10g and the queries will be very coupled to Oracle syntax/functions (i.e. text, mining, CONNECT BY, etc...). Thanks a lot. ...
I'm looking over .NET ORM implementations, and I have a major burning question - are there any .NET ORM implemenations that don't require public properties for every field in the database? When I see examples like this, a little bell goes off in my head. I firmly believe in encapsulation, and being forced to open the kimono of my objects...
I'm doing some werid reporting from JPA datastore. I need to select (using EJBQL) list of objects and these objects contain collection of entities ie I have class that is constructed by: FOOBean(String param1, String param2, List<Entity> listParam) (notice that third parapeter is a list) And I want to select list of thes...
In the following code, I'm tyring to create the method show_pro that will show all Arguments for the Case that are pro. I am getting this error: >>> Case.objects.all()[0].show_pro() Traceback (most recent call last): File "<console>", line 1, in <module> File "/home/john/mysite/../mysite/cases/models.py", line 23, in show_pro ...
UPDATE: I mistakenly pasted query code from the wrong overload. At the bottom is the fixed code Hi, let's say here's my domain. I'm tracking some sport Events like say car races. Each Race has Racers who take part in the race. Racer is a Driver in particular Race (it has the Driver, start lane, run-time, etc). Driver has things like...
I have a legacy schema that cannot be changed. I am using a base class for the common features and it contains an embedded object. There is a field that is normally mapped in the embedded object that needs to be in the persistence id for only one (of many) subclasses. I have made a new id class that includes it but then I get the error t...
I've come across a place in my current project where I have created several classes for storing a complicated data structure in memory and a completed SQL schema for storing the same data in a database. I've decided to use SQLAlchemy as an ORM layer as it seems the most flexible solution that I can tailor to my needs. My problem is tha...
I'm parsing an XML document that has nodes like the following: <objects> <dog> <data1>...</data1> <data2>...</data2> <data3>...</data3> </dog> <cat> <data1>...</data1> <data2>...</data2> <data3>...</data3> </cat> </objects> The elements data1, data2, data3 are always consistent. Only the parent tag vari...
How much effort would it take to migrate a large existing codebase from a Strongly Typed Dataset driven data access layer to a DAL driven by stored procs and/or a more modern ORM package? Is there any shiny tool that automates a portion of this process? The current code base has well over 100+ datasets mirroring the sql database (but ha...
What approach do you have towards creating and maintaining database indexes when using ORM such as NHibernate/Hibernate. Since the ORM is generating the queries, are there any tools you could recommend that could analyze query plans of those and suggest the kind of indexes that should be created? My current approach is ... wait until...
I want to separate data layer from business logic and business logic from GUI. Diving into web I stumbled upon a few resources but still unable to make my mind clear. Some people talk about patterns some others point various frameworks. My requirements are : manipulate data from rdbms (mysql mainly) CRUD operations dealing with id gen...
I am wondering why this framework (QCodo) is almost forgotten and totally unpopular. I've started using it a few years ago and it is the only thing that keeps me with PHP. Yeah ... its development is stuck (that's why there is now more active branch Qcubed) but it is still very good piece of software. Its main advantages: Event driv...