Override delete behaviour in NHibernate

Posted by David on Stack Overflow See other posts from Stack Overflow or by David
Published on 2010-04-07T15:21:10Z Indexed on 2010/04/07 15:23 UTC
Read the original article Hit count: 413

Filed under:

nhibernate

|

override

|

delete

|

sql

Hi all

In my application users cannot truly delete records. Rather, the record's Deleted field gets set to 1, which hides it from selects.

I need to maintain this behaviour and I'm looking into whether NHibernate is appropriate for my app. Can I override NHibnernate's delete behaviour so that instead of issuing DELETE statements, it issues UPDATES, as described above?

I would obviously also need to override its SELECT behaviour to include the 'AND Deleted = 0' clause. Or read from a view instead. I dunno.

TIA for your advice.

David

© Stack Overflow or respective owner

Related posts about nhibernate

How can I eager-load a child collection mapped to a non-primary key in NHibernate 2.1.2?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have two objects with a many-to-many relationship between them, as follows: public class LeftHandSide { public LeftHandSide() { Name = String.Empty; Rights = new HashSet<RightHandSide>(); } public int Id { get; set; } public string Name { get; set;… >>> More
Nhibernate 2.1 and mysql 5 - InvalidCastException on Setup

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello there, I am trying to use NHibernate with Spring.Net und mySQL 5. However, when setting up the connection and creating the SessionFactoryObject, I get this InvalidCastException: NHibernate seems to cast MySql.Data.MySqlClient.MySqlConnection to System.Data.Common.DbConnection which causes… >>> More
Nhibernate transactions:Avoiding Nhibernate dependency in the service layer

as seen on Stack Overflow - Search for 'Stack Overflow'
One of practices advocated by Nhibernate experts is to do all actions in inside a transaction. In a typical 3 tier web architecture, Nhibernate depedency is limited the data layer. In such a case is it fine to use using (var tr = NHibernateSession.Current.BeginTransaction()) { at the controller… >>> More
Series of abstract classes and NHibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, and first off thanks for your time to look at this. For a research project I'm working on, I have a somewhat complex design (which I've been given) to persist to a database via NHibernate. Here's an example of the class hierarchy: TransitStrategy, TransportationCompany and TransportationLocation… >>> More
Using Time columns with NHibernate, Fluent NHibernate and SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a table with a time column in my SQL Server 2008 database. The property of the object I'm trying to map to is a TimeSpan. How can i tell FluentNHibernate to use the TimeAsTimeSpan NHibernate type, so that I don't have cast problems? >>> More

Related posts about override

can you override an override in actionscript 3

as seen on Stack Overflow - Search for 'Stack Overflow'
Just curious, can you override an override in actionscript 3 >>> More
video and file caching with squid lusca?

as seen on Super User - Search for 'Super User'
hello all i have configured squid lusca on ubuntu 11.04 version and also configured the video caching but the problem is the squid cannot configure the video more than 2 min long and the file of size upto 5.xx mbs only. here is my config please guide me how can i cache the long videos and files with… >>> More
ASP.NET MVC2 Implementing Custom RoleManager problem

as seen on Stack Overflow - Search for 'Stack Overflow'
To create a custom membership provider I followed these instructions: http://stackoverflow.com/questions/2771094/asp-net-mvc2-custom-membership and these: http://mattwrock.com/post/2009/10/14/Implementing-custom-Membership-Provider-and-Role-Provider-for-Authinticating-ASPNET-MVC-Applications.aspx So… >>> More
java: List wrapper where get()/set() is allowed but add/remove is not

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to wrap a List<T> with some class that allows calls to set/get but does not allow add/remove calls, so that the list remains "stuck" at a fixed length. I think I have a thin wrapper class (below) that will work, but I'm not 100% positive. Did I miss anything obvious? import java.util… >>> More
hostname Override in firefox

as seen on Super User - Search for 'Super User'
Can I override a hostname in firefox? for example when I access www.example.com it should actually access localhost and not example.com Does any add-on provide that capability? >>> More