tagged [orm]

Primary Keys in Oracle and SQL Server

Primary Keys in Oracle and SQL Server What's the best practice for handling primary keys using an ORM over Oracle or SQL Server? - Should I use a sequence and a trigger or let the ORM handle this? Or ...

15 Aug at 21:8

How can ServiceStack.OrmLite ignore a property by attribute

How can ServiceStack.OrmLite ignore a property by attribute I'm trying to use ServiceStack.OrmLite. I'm using both ReferenceKey(CityId) and Reference (City). ReferenceKey is for Db creation, Reference...

14 Jun at 02:19

Does ServiceStack ormlite has the concept of transient attribute?

Does ServiceStack ormlite has the concept of transient attribute? I am newbie to servicestack and ormlite. I am trying to have fields to be used for displaying / serialization purposes not for persist...

What is the "N+1 selects problem" in ORM (Object-Relational Mapping)?

What is the "N+1 selects problem" in ORM (Object-Relational Mapping)? The "N+1 selects problem" is generally stated as a problem in Object-Relational mapping (ORM) discussions, and I understand that i...

23 May at 14:49

What is an ORM, how does it work, and how should I use one?

What is an ORM, how does it work, and how should I use one? Someone suggested I use an ORM for a project that I'm designing, but I'm having trouble finding information on what it is or how it works. C...

11 Jun at 16:31

How to use an include with attributes with sequelize?

How to use an include with attributes with sequelize? Any idea how to use an include with attributes (when you need to include only specific fields of the included table) with sequelize? Currently I h...

25 Apr at 17:54

Hibernate: flush() and commit()

Hibernate: flush() and commit() Is it good practice to call `org.hibernate.Session.flush()` separately? As said in `org.hibernate.Session` docs, > Must be called at the end of a unit of work, before c...

3 Oct at 11:22

Get the Query Executed in Laravel 3/4

Get the Query Executed in Laravel 3/4 How can I retrieve the raw executed SQL query in Laravel 3/4 using Laravel Query Builder or Eloquent ORM? For example, something like this: Or: Otherwise, at the ...

How to return dynamic types List<dynamic> with Dapper ORM

How to return dynamic types List with Dapper ORM I have been using Dapper.net for a while now and its a very good ORM mapper which works great with .Net dynamic types. But I noticed that when Dapper r...

30 May at 06:43

How to select a record and update it, with a single queryset in Django?

How to select a record and update it, with a single queryset in Django? How do I run an `update` and `select` statements on the same `queryset` rather than having to do two queries: - one to select th...

What is the proxy meaning in EntityFramework?

What is the proxy meaning in EntityFramework? I've used as an ORM in my projects and I don't have any problem in using this technology. I heard EntityFramework creates a proxy. I want to know WHAT pro...

2 Jan at 03:53

OrmLite Code-First approach keeping existing database data?

OrmLite Code-First approach keeping existing database data? I am trying Code-First approach of ServiceStack.OrmLite that will auto generate db structure. However, I find that the db structure will be ...

Hibernate show real SQL

Hibernate show real SQL if I set in my configuration file in the console I can see the SQL. But it's not SQL... Can I see the SQL code that will be passed directly to database? Example: I see Can I se...

4 Mar at 22:8

How to perform OR condition in django queryset?

How to perform OR condition in django queryset? I want to write a Django query equivalent to this SQL query: How to construct the Django queryset filter? This doesn't work, because it `AND`s the filte...

What are some good Entity Framework Alternatives

What are some good Entity Framework Alternatives I am using the Entity Framework now and constantly having to write inline sql because Entity framework does not support full text search and other feat...

3 Dec at 17:33

ServiceStack ORMLIte : Id is necessary

ServiceStack ORMLIte : Id is necessary I read on couple of articles that while using ORMLite, our objects must have Id property. One of the article is here: > [https://code.google.com/p/servicestack/w...

16 Dec at 02:40

Any thoughts on DevExpress XPO ORM Package?

Any thoughts on DevExpress XPO ORM Package? [XPO](http://www.devexpress.com/Products/NET/ORM/) is the object relational mapper of choice at my company. Any thoughts on the pros and cons? --- I was jus...

16 Dec at 18:15

ServiceStack.Net OrmLite Adding Autoincrement to table id without using an attribute

ServiceStack.Net OrmLite Adding Autoincrement to table id without using an attribute I am creating a Dal using OrmLite for persisting Models from a library which does not (and should not) have Orm-spe...

Bool type return rule

Bool type return rule I use dapper ORM.So i use two rules `Query` & `QuerySingle`. Query return the list & QuerySingle return the single object. So,I want to get a bool type. (Actually I wanted to get...

27 Sep at 07:46

When using an ORM, how to safely send loaded entities across the tiers

When using an ORM, how to safely send loaded entities across the tiers When a system has N tiers, and when using an ORM, how do you send loaded entities across the tiers ? Do you use DTO ? When DTO ar...

17 Sep at 22:5

Why do I get a "Null value was assigned to a property of primitive type setter of" error message when using HibernateCriteriaBuilder in Grails

Why do I get a "Null value was assigned to a property of primitive type setter of" error message when using HibernateCriteriaBuilder in Grails I get the following error when using a primitive attribut...

1 Jul at 01:33

How to select specific columns in laravel eloquent

How to select specific columns in laravel eloquent lets say I have 7 columns in table, and I want to select only two of them, something like this ``` SELECT `name`,`surname` FROM `table` WHERE `id` = ...

28 Apr at 16:39

Is Telerik openaccess ORM worth learning?

Is Telerik openaccess ORM worth learning? I have just won 1 Telerik Premium Collection for .NET Developer with subscription (lucky me!) and was wondering whether the OpenAccess ORM is worth learning? ...

28 Jul at 06:31

Async support in ServiceStack and OrmLite

Async support in ServiceStack and OrmLite Currently there exists an async branch of ServiceStack which will make it possible to create async services. But to get all benefits of async, all IO bound op...

Using Eloquent ORM in Laravel to perform search of database using LIKE

Using Eloquent ORM in Laravel to perform search of database using LIKE I want to use Eloquent's active record building to build a search query, but it is going to be a LIKE search. I have found the `U...

12 Jan at 16:14