CODEWITHSUNDEEP
c#mysqlnhibernatefluent-nhibernate
Adam
Adam

Reputation: 51

How to specify an auto-incrementing (int) identity column using Fluent-NHibernate and MySQL

The title basically says it all... I'm trying to specify an auto-incrementing (int) identity column using Fluent-NHibernate and MySQL. I've tried the following variations...

Id(x => x.ID).GeneratedBy.Native();
Id(x => x.ID).GeneratedBy.Identity();
Id(x => x.ID).GeneratedBy.Increment();

...and tried setting default values on each.

Note: I'm using an int data type and have received errors such as...

"Input string was not in a correct format."

or...

"Field 'ID' does not have a default value'

Upvotes: 4

Views: 9706

Answers (2)

gsahoo
gsahoo

Reputation: 109

I'm using

public class User
    {
        public virtual int Id { get; set; }
        public virtual IList<Names> Names { get; set; }
        public virtual IList<Addresses> Addresses { get; set; }
    }

and mapping as Increment and works for me.

Id(x => x.Id).GeneratedBy.Increment();

Upvotes: 8

Koteswara sarma
Koteswara sarma

Reputation: 434

In MySQL you can create a column and mention its properties as AUTO_INCREMENT and DEFAULT VALUE 1 (or whatever you wish), why don't you use it?

--Cheers

Upvotes: -3

Related Questions