Say I have an application that used an ORM (I am thinking of nHibernate or LINQ to Entities) for data access. How do I provide my users with the ability to do reporting against the properties of my objects? All the end user report designers I know of talk directly to a database, but I don’t like having to repeat logic in reports that ...
I have a Java object that I want to store in a local in-memory database. The Object has a One-Many FK relationship, otherwise it has 20 or so Integer/String/Enumerated fields. I would like to avoid using a framework. Even though the objects themselves are not very large, there will be a large amount of these objects being inserted/u...
So, I asked before what a good ORM was and the answer seemed to be nhibernate. I went through the giant learning curve and well it’s awesome, but totally won’t work for me. I sadly must use stored procedures and its ability to use them is very limited. So I have Business objects (DEVELOPERS WRITE) and some SPROCS (DBA WRITE)…… I know wh...
Let's say I have the following function I want to test: public void CancelOrder(Order order) { order.Status = "Cancelled"; _emailService.SendEmail(order.User.Email, "Your order has been cancelled!"); } Now, the Order class is a SubSonic generated class and the User property on it is lazy-loaded, meaning that when I call order...
It is a quite common situation in our applications that some entity have to be represented by an enum: for example types, categories, status, and things like that. Often, there are conditions or flows in the code that use the values to decide between one action or another, so the values have to be "known" in some way for the applicatio...
How do you guys treat empty strings with Oracle? Statement #1: Oracle treats empty string (e.g. '') as NULL in "varchar2" fields. Statement #2: We have a model that defines abstract 'table structure', where for we have fields, that can't be NULL, but can be "empty". This model works with various DBMS; almost everywhere, all is just fine...
Hi to all, we're working on an application that digs data from an Oracle DB and a SQLServer one. In need for a (possibly free) ORM solution, I'd like to use Entity Framework, but it does not support Oracle. Any suggestion? Thanks ...
I am looking for some up to date information comparing NHibernate and iBATIS.NET. I found some information searching Google, but a good bit of it applies either to the Java versions of these products or is dated. Some specific things I am interested in: Which is better if you control both the data model and the application? iBATIS is...
I am starting a new ASP.Net MVC project and was wondering what is the best Model approach to take. Most demos recommend LinqToSQL but I know Microsoft are not really enhancing this product and are focusing more on the Entity Framework. I like the Subsonic approach but I thought this was going to be built in with MVC with version 3 bu...
What ORM do stackoverflow use with their ASP.Net MVC project? ...
I was just reading about Linq to SQL being discontinued. For a while I put off learning Linq at all. Even on asp.net, when I last checked, their data access tutorials were using table adapters and bll classes. Then there are linq tutorials. Now that I have read this and that the Entity Framework is the new way to go, does that mean a...
I really like ORM as compared to store procedure, but one thing that I afraid is that ORM could be slow, because of layers and layers of abstraction. Will using ORM slow down my application? Or does it matter? ...
I have a situation utilizing class table inheritance where the base object (which is abstract) is extended by specific types of the object. For example, Person --> User --> Prospect However, in some instances like with Prospect, sometimes it extends User and sometimes it doesn't. I can't reverse the relationship because User !== Prospe...
I'm getting the above exception while trying to read data from a table using Linq2Sql. Does anyone know what's happening here? ...
I see this pattern everywhere, but Linq to SQL does not implement it. If Session/Unit-of-Work objects are lightweight (can be created and destroyed without performance penalty), and connection pooling keeps database connections alive, why and when do I need the session-per-request pattern? ...
I am creating database Entities in my Java application and trying to rationalize between using an Integer or a Long as the class type of the "id" field. I am using Hibernate as my ORM which, in turn, will map this field to a column in the HSQLDB database. My struggle is this: a Long is obviously larger and will handle a greater number o...
How is it possible to create an entity in the visual studio designer and generate a table from it? I find it much easier to generate my entities within VS than to create a table in SQL Server. Also, if I do generate an entity from table, is it possible to make changes to the entity and push them to the table? ...
I am having a problem giving a LINQ predicate the knowledge it needs to sort either alphabetically or numerically. I am working with a multi-value pivoted set of data with has a sortable column. The column is always stored as varchar in the DB, however, it has lookup knowledge of what that data type actually is. To simplify, in additio...
We're in the process of planning a large, enterprise application. We're focusing our efforts on evaluating hibernate after experiencing the pains of J2EE. It looks like the new JEE API is simpler. I've also read some good things about Hibernate and iBatis. Our team has little experience with any of the frameworks. There are 5 main co...
The "party model" is a "pattern" for relational database design. At least part of it involves finding commonality between many entities, such as Customer, Employee, Partner, etc., and factoring that into some more "abstract" database tables. I'd like to find out your thoughts on the following: What are the core principles and motiva...