Fluent nHibernate string length issue

Question

I am trying to set the length for an nvarchar, but no success - it is still nvarchar(255).

I am getting this error; "String or binary data would be truncated.\r\nThe statement has been terminated."

Map(x => x.Text).CustomType("StringClob");
//.Length(4001);
//.CustomSqlType("varchar(max)");
//.Length(10000);
//.WithLengthOf(10000);
//.CustomType("varchar(MAX)");
//.CustomSqlType("ntext");

irotaev · Accepted Answer · 2014-06-30 09:22:52Z

1

Try to use update scheme option in fluent configuration, not to face with such problem again.

As you wrote, you get constraint limitation of ms sql.

answered Jun 30, 2014 at 9:22

irotaev

697 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mert Over a year ago

but that configuration resets database everytime?

irotaev Over a year ago

No that configuration allow db to update scheme only when your current scheme changed. And it means that even on scheme update you will not loose your data. It is absolutly constraint safty process, otherwise you can't update constraint limitation, as foreign key delete. But it has no need in 99% cases. Good luck :)

Mert Over a year ago

I will try it out after backup db :)

Mert · Accepted Answer · 2014-06-30 09:02:03Z

0

I solved it by deleting table manually, then .Length(4001); worked.

answered Jun 30, 2014 at 9:02

Mert

6,6127 gold badges34 silver badges74 bronze badges

Collectives™ on Stack Overflow

Fluent nHibernate string length issue

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related