Someone I know wants to use diconnected recordsets in an application. To me it sounds like if I have a ORM tool there would really be no need to even touch disconnected recordsets. The way I understand it with ORM the ORM takes care of not hugging connections for unnecessarily long amounts of time, solving the need for a disconnected rec...
Microsoft Linq to SQL, Entity Framework (EF), and nHibernate, etc are all proposing ORMS as the next generation of Data Mapping technologies, and are claiming to be lightweight, fast and easy. Like for example this article that just got published in VS magazine: http://visualstudiomagazine.com/features/article.aspx?editorialsid=2583 Wh...
I am currently playing around with the HybridSessionBuilder class found on Jeffrey Palermo's blog post: http://jeffreypalermo.com/blog/use-this-nhibernate-wrapper-to-keep-your-repository-classes-simple/ Using this class, my repository looks like this: public class UserRepository : IUserRepository { private readonly ISessionBuilder...
I'm trying to figure out how to use NHibernate configuration with mapping to update table schemas, rather than dropping and recreating them. Currently I'm using the NHibernate.Tool.hbm2ddl.SchemaExport obj with FluentNHibernate to generate the database schema for a mysql database. While I can't say it's a huge problem, whenever I call ...
I know of Rational Rose and we have got Rational Rose 6. But I am looking for some other tools which are more usable, which do not complain that they are not running in Windows 98/2000 (when installed and run in WinXP) and has got better features as compared to Rational Rose 6. ...
Hi guys do any of you working on a large enterprise or web application what uses Nhibernate as an ORM tool ,I interested to know about your experience ? Or maybe you have a link for such an example ? ...
I am using Hibernate 3.x, MySQL 4.1.20 with Java 1.6. I am mapping a Hibernate Timestamp to a MySQL TIMESTAMP. So far so good. The problem is that MySQL stores the TIMESTAMP in seconds and discards the milliseconds and I now need millisecond precision. I figure I can use a BIGINT instead of TIMESTAMP in my table and convert the types i...
Anyone working on the Android ('gPhone') have or know of a place where I can find a good ORM tool for it? The code is written in Java, and the DB is SQLite. What I would like to find is a tool that given the object definition, can auto-generate the tables and the CRUD functions (that would be awesome), or, barring that, a tool that can...
What is the best practice to implement the following: we have a classes Order and OrderItem as parent-child. Class OrderItem provides property Cost On the OrdersList form we have to see MaxCost column = max(cost) from Items collection I found only one usefull solution here which won't break the DDD concpts: to add a usual prop...
Hi, Are there any O/R mappers out there that will automatically create or modify the database schema when you update the business objects? After looking around it seems that most libraries work the other way by creating business object from the database schema. The reason I'd like to have that capability is that I am planning a product...
I'm working on creating a domain layer in Zend Framework that is separate from the data access layer. The Data Access Layer is composed to two main objects, a Table Data Gateway and a Row Data Gateway. As per Bill Karwin's reply to this earlier question I now have the following code for my domain Person object: class Model_Row_Person { ...
I have a database structure that has a Person table which contains fields such as name, email, company_id, personType and the like. Because not all Person's are necessarily system user's, I have a separate table User that defines userName and password for those Person's that are User's in the system. I have the following code to define ...
I have looked at NHibernate and EntitySpaces and they both seem to work differently. In EntitySpaces, you define the database tables and table relationships and the classes are generated for you. In NHibernate, you define the classes and the table relationships are generated for you. This is what I am looking for. Are there any other ...
Suppose you store instances of a class in a relational table. How would you go about persisting a static attribute of that class? For example: class WebSiteUser { private static $common_homepage_content; private $username; private $password_hash; ... } Corresponding to: CREATE TABLE web_site_users ( username charact...
There are many ORM solutions out there, so in your experiences what seems to be the best choice? NHibernate or Subsonic, Genome,DLinq, LLBLGen - there seems to be a plethora of options, so pros and cons please people. ...
From a previous question, I learn that Linq to SQL is not able to eager load only certain files of foreingKey tables. So I'm asking what .net ORM can support including this type of statement inside a entity class, with only one DB call and without manually mapping the result with the object. -- simplified for clarity SELECT Order.*...
I've just started using NHibernate and fluent-NHibernate which I think is great. I've been configuring all my mappings to use LazyLoading for any relationships between classes because generally I find it isn't neccesary to load everything upfront. However sometimes you know 100% you will be loading all of the relationships or at least on...
I'm creating a simple tag system that allows me to link a tag to almost everything in my application. In order to facilitate this, I created a table called "objects", referenced by my model "Object". I've got three models setup at the moment: Tag (with TagObject defined as a dependentTable) Object (with TagObject defined as a depended...
I've been investigating what data layer to use for a new web-based project I'm designing and I'm very keen to look at incorporating LINQ to SQL. Its apparent simplicity, flexibility and designer support really appeals and the implicit tie-in to SQL Server is fine. However, it has been announced recently that LINQ to SQL will be taking a...
I am just getting started with NHibernate (for the 15th time it would seem) and am having the following problem. The following table: Table Facility Column FACILITY_ID integer Column NAME varchar2(50) Column MONTH varchar2(5) For whatever reason, month is a string instead of a native Date type and looks like this: "200811" represent...