Perhaps you don't have the latest version of the code base? http://github.com/jagregory/fluent-nhibernate/blob/master/src/FluentNHibernate/Mapping/IdentityPart.cs
<http://github.com/jagregory/fluent-nhibernate/blob/master/src/FluentNHibernate/Mapping/IdentityPart.cs>(towards the bottom, you'll see theres a CustomSqlType method) On Mon, Mar 8, 2010 at 3:16 AM, Isaac Inyang <isaac.iny...@gmail.com> wrote: > Paul, > > From my experience, CustomSqlType is only available to PropertyPart (i.e. > the Map method) but not to IdentityPart (i.e. the Id method). > > Is there some way to get this done? > > Thank you. > > Isaac > > > > > On Sun, Mar 7, 2010 at 1:51 PM, Paul Batum <paul.ba...@gmail.com> wrote: > >> I believe something like this should do it: >> >> Id(i => i.PersonId) >> .CustomSqlType("MEDIUMINT") >> .GeneratedBy.Identity(); >> >> >> On Thu, Mar 4, 2010 at 8:26 PM, Isaac Inyang <isaac.iny...@gmail.com>wrote: >> >>> Hello, >>> >>> Using Fluent NHibernate, how do I specify the *Custom SQL Type* which my >>> *Identity *properties will be mapped to? >>> >>> Specifically, I want all Int32 fields to be mapped to MEDIUMINT (3 bytes) >>> within MySQL. Referring to the code below, I want PersonId to be of type >>> MEDIUMINT in the database. >>> >>> *Entity Definition*: >>> >>> public class Person >>> { >>> public virtual int PersonId { get; set; } >>> public virtual string FullName { get; set; } >>> public virtual int Age { get; set; } >>> } >>> >>> *Mapping Class*: >>> >>> public class PersonMap : ClassMap<Person> >>> { >>> public PersonMap() >>> { >>> Id(i => i.PersonId).GeneratedBy.Identity(); >>> Map(i => i.FullName); >>> Map(i => i.Age).CustomSqlType("mediumint"); >>> } >>> } >>> >>> *Generated HBM File*: >>> >>> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" >>> default-access="property" auto-import="true" default-cascade="none" >>> default-lazy="true"> >>> <class xmlns="urn:nhibernate-mapping-2.2" >>> name="netquepgcurrent.Entities.Person, netquepgcurrent, Version=1.0.0.0, >>> Culture=neutral, PublicKeyToken=null" table="`Person`"> >>> <id name="PersonId" type="System.Int32, mscorlib, Version=2.0.0.0, >>> Culture=neutral, PublicKeyToken=b77a5c561934e089"> >>> <column name="PersonId" /> >>> <generator class="identity" /> >>> </id> >>> <property name="FullName" type="System.String, mscorlib, >>> Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> >>> <column name="FullName" /> >>> </property> >>> <property name="Age" type="System.Int32, mscorlib, Version=2.0.0.0, >>> Culture=neutral, PublicKeyToken=b77a5c561934e089"> >>> <column name="Age" sql-type="mediumint" /> >>> </property> >>> </class> >>> </hibernate-mapping> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Fluent NHibernate" group. >>> To post to this group, send email to fluent-nhibern...@googlegroups.com. >>> To unsubscribe from this group, send email to >>> fluent-nhibernate+unsubscr...@googlegroups.com<fluent-nhibernate%2bunsubscr...@googlegroups.com> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/fluent-nhibernate?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Fluent NHibernate" group. >> To post to this group, send email to fluent-nhibern...@googlegroups.com. >> To unsubscribe from this group, send email to >> fluent-nhibernate+unsubscr...@googlegroups.com<fluent-nhibernate%2bunsubscr...@googlegroups.com> >> . >> For more options, visit this group at >> http://groups.google.com/group/fluent-nhibernate?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Fluent NHibernate" group. > To post to this group, send email to fluent-nhibern...@googlegroups.com. > To unsubscribe from this group, send email to > fluent-nhibernate+unsubscr...@googlegroups.com<fluent-nhibernate%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/fluent-nhibernate?hl=en. > -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to fluent-nhibern...@googlegroups.com. To unsubscribe from this group, send email to fluent-nhibernate+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en.