Hi, i have the following code, which is supposed to give specific functionality but it isn't :S anyway, here's my problem: http://img525.imageshack.us/img525/1315/diagramp.png here's the mapping code: public class UsersMap : ClassMap<User> { public UsersMap() { this.Table("Users"); Id(x => x.UserName).Generat...
Hi, I've got an array of values I want to update my model with. Doctrine_Access provides a function setArray which is nearly exactly what I need - except it cares about values that don't have fields in the model. I want those to be ignored. A little example. Say we have a User table with the field username. $user = new User(); $user-...
Hello, I'm trying to figure out the best way to handle a simple problem: I have a simple LINQ join to two tables. I know how to return the type for one table, since it is the same as the generated dbml class. However, what if I want to return data from both tables- isn't there a way to return both and use their relationships? Do I rea...
Here is my problem, i'm trying to do tag cloud in symfony, what i want to perform is such a sql query select tag, count(tag) from tagi group by tag order by count(tag) desc limit 10 anyone can help? ...
I am writing web application and am wondering what the recommended way is to populate initial data. This is JPA/Hibernate and Spring application and is built by maven. Up to now I've used script wich populate database with initial data, started by hand. Unit tests work with theirs own data, created in code before each test. My test clas...
I am looking for options other than MS SQL Server/Express. There seem to be quite a few file based or in-memory database engines supporting some subset or dialect of SQL. Preferably it would be an engine not requiring installation at all. Is any of them supported by SimpleRepository? Is any of them supported by ActiveRecord? Is there at...
Hey Everyone, I like using SQL, and I think I am pretty good with it. And I tried to use Linq (with c# and Linq2Sql, looks like it feels more SQL-like with VB.Net), I feel it is very frustrating, you cannot just run your query without compiling and executing the code. I am not so great with IQueryable, IEnumarable, IList etc. And I hav...
DataSet is not ORM but it is possible to build an ORM with Dataset http://www.15seconds.com/issue/080103.htm This kind of article is very rare as people seem to oppose Datasets and ORMs so any other example ? ...
I am using Visual Studio 2005, Sql Server 2005, C#, ADO.NET. We have a very large database and routinely adding new stored procedures. I am tired of writing the C# wrapper code for these stored procedures, seems like there should be some simple utility or Add In that would allow me to simply point to a stored procedure and generate s...
Hi all! I am going to make an web application where a lot of users are going to input data into a SQL Server with ASP.NET 3.5. There will be no heavy load of data sent to the client as data will be set to pagesized from the database. Stored procedures are used. I am asking you guys with experience in web 2.0 aka AJAX, jQuery and other cl...
I'm project managing an intranet application being developed at work. We're in the early planning stages. I've previously done all my development in Python using Django, but as we're a windows shop we're probably going to go with ASP.NET MVC. We won't really be able to afford a SQLServer license though, so we were perhaps looking into u...
I'm searching for an ORM framework for .NET 2.0 (has to run on Windows 2000, so 3.0/3.5 is out) that is entirely code configured, and does not require XML. I need this to be "hard coded" in the app so that the app can be stand-alone and copied without any support files. I've looked at most of the common ones like nHibernate and the XML...
How external ORMs simplify anything when you have to cope with complex XML configuration like the Java EJBs ? Complexity just hide somewhere else. Moreover It introduces dependencies on External 3rd parties above the dependencie to Microsoft. So where's the advantage ? ...
A common approach to data modelling is to use a data modelling tool (e.g. Erwin) to generate a schema, and then from the schema to generate business objects using an object relational mapper (ORM). Less common is the reverse process where the data modelling is done using business objects (e.g. POCO/POJO's), from which the schema is gene...
How can I get Hibernate (using JPA) to create MySQL InnoDB tables (instead of MyISAM)? I have found solutions that will work when using Hibernate to generate an SQL file to create the tables, but nothing that works "on the fly". ...
We are about to use Code Protectors (Obsfucation as well as Native Compilation), I assume ORMs will be dependent little bit on Reflection and I am worried will Obsfucation and Native Compilation protection techniques create any problems? Has anyone tried successful ORM and Code Protection for any good desktop application? We are having ...
Could someone possibly provide code to a very simple activerecord class that I could use to learn with? Looking at the source on projects like Castle and SubSonic is a bit overwhelming. I'd like to learn the active record pattern to get an idea of how it works. I know whatever I build would be nothing compared to Castle or SubSonic, but ...
I have a tree like structure created out of models using ForeignKey linkages. As an example: Model Person: name = CharField Model Book: name = CharField author = FK(Person) Model Movie: name = CharField director = FK(Person) Model Album: name = CharField director = FK(Person) Model Chapter...
We are currently using SubSonic as our persistence layer because it's light but also because it allows us to feed in test data so our DAL can be tested without hitting the database. I absolutely love that about SubSonic. However, because we are also running into other issues with SubSonic, I'm now looking for an alternative while our p...
Hi, I'm porting a medium-sized CRUD application from .Net to Qt and I'm looking for a pattern for creating persistence classes. In .Net I usually created abstract persistence class with basic methods (insert, update, delete, select) for example: public class DAOBase<T> { public T GetByPrimaryKey(object primaryKey) {...} public ...