Posted
by Michael Hedgpeth
on Stack Overflow
See other posts from Stack Overflow
or by Michael Hedgpeth
Published on 2010-03-10T17:47:15Z
Indexed on
2010/03/14
23:59 UTC
Read the original article
Hit count: 285
If I am using a hilo generator with nhibernate, what should the datatype for my id column be? int or bigint?
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
Im currently using the hilo id generator for my classes but have just been using the minimal of settings eg
<class name="ClassA"
<id name="Id" column="id" unsaved-value="0"
<generator class="hilo" /
</id
...
But should I really be specifying a new column for NHibernate…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
This is the same question as: http://stackoverflow.com/questions/803872/hilo-or-identity
Let's take the database of this site as an example.
Lets say that the site has the following tables:
Posts.
Votes.
Comments.
What is the best strategy to use for it:
Identity - which is more common.
OR
HiLo…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm using the HiLo generator in my S#rpArchitecture/NHibernate project and I'm performing a large import batch.
I've read somewhere about the possibility to predict the Low values of any new records because they are generated on the client. I figure this means I can control the Low values myself…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I have started using the s#arp architecture which uses FNhibernate and GeneratedBy.HiLo to generate primary keys (there is also table hibernate_unique_key). Apparently, this is recommended practise and I would like to stick with this. Now to my problem. I have used NHibernate and hbm mapping…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm struggling to get my head round how the HiLo generator works in NHibernate. I've read the explanation here which made things a little clearer.
My understanding is that each SessionFactory retrieves the high value from the database. This improves performance because we have access to IDs without…
>>> More
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
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
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
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
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
