To perform a distinct query you can set the projection on the criteria to Projections.Distinct. You then include the columns that you wish to return. The result is then turned back into an strongly-typed object by setting the result transformer to AliasToBeanResultTransformer – passing in the type that the result should be transformed into. In … Read more
Here’s a practical example. Let’s say that you have an online store and one of your domain classes is a Brand like “Samsung”. This class has a boatload of properties associated with it, perhaps an integer Identity, a Name, a free-text Description field, a reference to a Vendor object, and so on. Now let’s say … Read more
Stateless session is not tracking entities that are retrieved. For example for regular ISession following code: var session = sessionFactory.OpenSession() using(var transaction = session.BeginTransaction()){ var user = session.Get<User>(1); user.Name = “changed name”; transaction.Commit(); } will result in update in DB. This tracking consumes memory and makes ISession performance to degrade over time since amount of … Read more
ExecuteUpdate on SQL Query should help you. Sample: ISession session = …. IQuery query = session.CreateSQLQuery(“exec LogData @Time=:time, @Data=:data”); query.SetDateTime(“time”, time); query.SetString(“data”, data); query.ExecuteUpdate();
Fluent NH Fluent NHibernate offers an alternative to NHibernate’s standard XML mapping files. Rather than writing XML documents, you write mappings in strongly typed C# code. This allows for easy refactoring, improved readability and more concise code. vs. NH’s new mapping by code It is an XML-less mapping solution being an integral part of NHibernate … Read more
I find that there are valid reasons for using an interface instead of a concrete class as a property. For example, if your Field class was in a seperate project to the Address class, and you didn’t have a dependency on the Address class’s project from the Field class’s project. There are other ways of … Read more
NHibernate 3.2 comes with its own proxy factory. If you’re using a config file, you just need to remove the proxyfactory configuration property. I believe the version of Fluent NHibernate that you’re using defaults to use NHibernate.ByteCode.Castle. In that case, you would need to override that setting with the built in NHibernate 3.2 proxy factory: … Read more
This post from one of the authors might have your answer: Even if we are only reading data, we want to use a transaction, because using a transaction ensure that we get a consistent result from the database. NHibernate assume that all access to the database is done under a transaction, and strongly discourage any … Read more
Ok, I wrote an example for myself reflecting your structure and this should work: int projectId = 1; // replace that with the id you want // required for the joins in QueryOver Project pAlias = null; Partner paAlias = null; PartnerCosts pcAlias = null; Address aAlias = null; Money mAlias = null; // Query … Read more
I have now found out that I could use the Take() extension method on the IQueryOver instance, and only the enumerate to a list, like so: Result precedingOrMatchingResult = Session.QueryOver<Result>(). Where(r => r.TimeStamp < timeStamp). OrderBy(r => r.TimeStamp).Desc. Take(1).List(). //enumerate only on element of the sequence! FirstOrDefault(); //get the preceding or matching result, if there … Read more