My object model represents a podcast feed, with channel data and feed items (individual podcasts). This is structured as follows: PodcastFeed ChannelData // Property on PodcastFeed ITunesChannelData // Property on ChannelData FeedItems // Property on PodcastFeed; collection of PodcastFeedItems PodcastFeedItem ITune...
What I have here is a bunch of XML-Files containing data and a nice ER-Model to which the data belongs. What my problem is: I need to get this data into a db2. The tables with all necessary attributes and keys are already created. I was thinking of three different solutions: Parsing the XML and creating SQL-Queries from it. This solut...
I am going to use SQL Server in my project, for that I want to select an ORM with it. I have some experience with NHibernate as an ORM. In fact, given the nature of that project ( MySQL the backend) NHibernate is really, the only choice. I have also used strongly typed dataset as my ORM, and that's having Microsoft Access as the backe...
I have an EntityObject named Pathway which relates directly to data in the pathway table. My database also stores rules for Pathway customisations. What I would like to do is create a Pathway object in my code that is the resultant of the Pathway + PathwayCustomisations. The resultant should never find it's way back to the database, it i...
Do any of the available ORMs support using a bit field to represent row removal? More information. Working in C#. I need to delete this way to support synchronization of remote database changes to a central database. I'm looking for a possible ORM, but am also interested in approaches to the problem. So if anyone knows any ORM in an...
I'm interested in using Doctrine as an ORM for a new Zend Framework app I'm writing. I'm trying to figure out the best way to integrate it as straightforward as possible. Every example I find is different, and a lot of them pre-date the new autoloading features in ZF 1.8. None of them have worked for me yet. Does anyone have a good way ...
Let us suppose we'd like to use very helpful framework (for example ORM or UI framework), that in general matches you requirements, but requires installing and using third-party tool like PostSharp (tool, that implements AOP modifying compiled code on post-build stage) or something like this. On the one hand it can significantly improve...
Hi, I have the following JPA SqlResultSetMapping: @SqlResultSetMappings({ @SqlResultSetMapping(name="GroupParticipantDTO", columns={ @ColumnResult(name="gpId"), @ColumnResult(name="gpRole"), // @ColumnResult(name="gpRemarks") } ) Which is used like this: StringBuilder sbQuer...
Is there anyone out there that has used the Telerik product and had good experiences with it, especially if you have also tried other ORM's? Are there specific advantages to Telerik's product that warrant the price tag? Why would I choose it over something free like nHibernate? EDIT: Telerik says they are "Reflection-Free." Is there a...
I would like to use postgresql with foreign keys to define relationships in data so that other platforms/apps would also be able to easily use the same database. Having some kind of ruby DSL to define database schema with migration support would also be great. Which framework would you recommend for me? Is there some kind of framework f...
Is there a pretty way to execute an SQL statement with a LIKE clause in SQLObject? This one: fields = Foo.select("field LIKE '%%%s%%'" % bar) works, but it's somewhat ugly. ...
We are getting ready to begin redevelopment of a large aging internal enterprise application. We have decided to use ASP.NET MVC, but under consideration is which Object Relational Mapping (ORM) to choose. There are of course a multitude of open source and paid ORM implementations available. However, NHibernate seems to hold the largest ...
Can you give me an example of a Hibernate mapping for the following situation: Parent table(foo) with a simple primary key (foo_id) child table(bar) with a composite key consisting of a> Foreign key to parent table (foo_id) b> key(item) of type string There is one parent to many child The Parent class will have a list of Child objects...
I am interested in learning NHibernate. So, I found this: http://www.summerofnhibernate.com/ I would like to watch these, but I am afraid that the videos are for a previous version of NHibernate. Is this true and if so should I still watch them? Is there a current video series? Any other suggestions for learning NHibernate? ...
Hi, Has anybody tried Signum Framework ? Signum Framework is the new Open Source framework from Signum Software for writing data-centric applications over the latest Microsoft technologies: .Net 3.5, C# 3.0, WPF, ASP.Net MVC. It provides a consistent model for N-layer architectures by moving the entities to the very center of your solu...
I'm looking for an ORM that allows me to do bulk inserts, as well as create code based on python classes. I tried sqlobject, it worked fine for creating the tables but inserting was unacceptibly slow for the amount of data I wanted to insert. If such an ORM doesn't exist any pointers on classes that can help with things like sanitizing i...
Or possibly there is a better way. I am building a dynamic query builder for NHibernate, we don't want to put HQL directly into the application, we want it as ORM agnostic as possible. It looks like this currently: public override IEnumerable<T> SelectQuery(Dictionary<string, string> dictionary) { string t = Convert.ToSt...
Ok, so everyone has decided (and for good reason) strait SQL is of the devil. This leaves us with many methods of placing a "middle-man" in our code to separate our code from the database. I am now going to spit out all the info I have gathered in the hope someone can set me strait and tell me what I built. An ORM (Object-relational map...
our team is looking to use a code generation tool for the current sharepoint application we are working on. We want to be able to generate most of the stored procedures and business entities instead of having to write them from scratch. Any recommendation what is the best code generation tool to use with sharepoint projects. I am familia...
I realize that this may be tantamount to asking, "what's the best programming language?" (lots of debate and emotion), but I don't know what do but ask YOU about what Web Frameworks you've had good experience with. Practically, to be adopted by our IT folks it needs to be HOSTED on Java; thus the two I listed in the subject above. I ins...