Databases
StackOverflow2013
Postsdbo
POHow do I create/use a Fluent NHibernate convention to automap UInt32 properties to an SQL Server 2008 database?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I create/use a Fluent NHibernate convention to automap UInt32 properties to an SQL Server 2008 database?
    primarykey
    data
    text
    <p>I'm trying to use a convention to map UInt32 properties to a SQL Server 2008 database. I don't seem to be able to create a solution based on existing web sources, due to updates in the way Fluent NHibernate works - i.e. examples are out of date.</p> <p>I'm trying to have NHibernate generate the schema (via ExposeConfiguration). I'm happy to have NHibernate map it to anything sensible (e.g. bigint).</p> <p>Here's my code as it currently stands (which, when I try to expose the schema, fails due to SQL Server not supporting UInt32). Apologies for the code being a little long, but I'm not 100% sure what is relevant to the problem, so I'm erring on the side of caution. Most of it is based on <a href="https://stackoverflow.com/questions/2309072/nhibernate-how-to-store-uint32-in-database">this post</a>.</p> <p>The error reported is:</p> <pre><code>System.ArgumentException : Dialect does not support DbType.UInt32 </code></pre> <p>I think I'll need a relatively comprehensive example, as I don't seem to be able to pull the pieces together into a working solution, at present.</p> <pre><code>FluentConfiguration configuration = Fluently.Configure() .Database(MsSqlConfiguration.MsSql2008 .ConnectionString(connectionString)) .Mappings(mapping =&gt; mapping.AutoMappings.Add( AutoMap.AssemblyOf&lt;Product&gt;() .Conventions.Add&lt;UInt32UserTypeConvention&gt;())); configuration.ExposeConfiguration(x =&gt; new SchemaExport(x).Create(false, true)); namespace NHibernateTest { public class UInt32UserTypeConvention : UserTypeConvention&lt;UInt32UserType&gt; { // Empty. } } namespace NHibernateTest { public class UInt32UserType : IUserType { // Public properties. public bool IsMutable { get { return false; } } public Type ReturnedType { get { return typeof(UInt32); } } public SqlType[] SqlTypes { get { return new SqlType[] { SqlTypeFactory.Int32 }; } } // Public methods. public object Assemble(object cached, object owner) { return cached; } public object DeepCopy(object value) { return value; } public object Disassemble(object value) { return value; } public new bool Equals(object x, object y) { return (x != null &amp;&amp; x.Equals(y)); } public int GetHashCode(object x) { return x.GetHashCode(); } public object NullSafeGet(IDataReader rs, string[] names, object owner) { int? i = (int?)NHibernateUtil.Int32.NullSafeGet(rs, names[0]); return (UInt32?)i; } public void NullSafeSet(IDbCommand cmd, object value, int index) { UInt32? u = (UInt32?)value; int? i = (Int32?)u; NHibernateUtil.Int32.NullSafeSet(cmd, i, index); } public object Replace(object original, object target, object owner) { return original; } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USdommer
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do I create/use a Fluent NHibernate convention to automap UInt32 properties to an SQL Server 2008 database?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COpossible duplicate of [Best way to store UInt32 in Sql Server](http://stackoverflow.com/questions/694211/best-way-to-store-uint32-in-sql-server)
      singulars
      1. POHow do I create/use a Fluent NHibernate convention to automap UInt32 properties to an SQL Server 2008 database?
      1. USgbn
    2. CO@gbn. This is primarily a Fluent NHibernate question, so definitely not addressed by the post you refer to. I want to know how to create a Fluent NHibernate mapping when I have a UInt32 property. I'm comfortable with the options for casting from UInt32 to other numeric types.
      singulars
      1. POHow do I create/use a Fluent NHibernate convention to automap UInt32 properties to an SQL Server 2008 database?
      1. USdommer
    3. COSee my answer then. It may be a Fluent NHibernate question but the issue is how to map Unint32 to a SQL Server datatype... which could be any client or ORM...
      singulars
      1. POHow do I create/use a Fluent NHibernate convention to automap UInt32 properties to an SQL Server 2008 database?
      1. USgbn
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload