Mapping large string with Fluent NHibernate

Question

I'm working with an Oracle DB, and I'm trying to map this class:

public class Book
{
    public virtual int Id { get; private set; }
    public virtual string Author { get; set; }
    public virtual string Title { get; set; }
    public virtual string Text { get; set; }
}

With this mapping class:

public class BookMap : ClassMap<Book>
{
    public BookMap()
    {
        Id(x => x.Id);
        Map(x => x.Author);
        Map(x => x.Title);
        Map(x => x.Text);
    }
}

But the column type that it generates me is NVARCHAR(255), And the Book.Text Property has much more than 255 characters.

How can I map it to a type that can contain a very large string (for example CLOB)?

see stackoverflow.com/questions/2343105/…

Chris S
– Chris S

2012-10-30 14:20:50 +00:00
Commented Oct 30, 2012 at 14:20 — Chris S
– Chris S, Commented Oct 30, 2012 at 14:20

Tim Hoolihan · Accepted Answer · 2010-06-23 20:58:25Z

11

public class BookMap : ClassMap<Book>
{
    public BookMap()
    {
        Id(x => x.Id);
        Map(x => x.Author);
        Map(x => x.Title);
        Map(x => x.Text).CustomSqlType("CLOB");
    }
}

or

public class BookMap : ClassMap<Book>
{
    public BookMap()
    {
        Id(x => x.Id);
        Map(x => x.Author);
        Map(x => x.Title);
        Map(x => x.Text).Length(500);  // nvarchar(500)
    }
}

edited Jun 23, 2010 at 20:58

answered Jun 23, 2010 at 20:50

Tim Hoolihan

12.4k3 gold badges43 silver badges54 bronze badges

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

3 Comments

Chris S Over a year ago

Do you mean CustomType("StringClob") ?

Tim Hoolihan Over a year ago

@ChrisS. StringClob is for SQL Server, the question was about Oracle

Seb T. Over a year ago

After being mislead by this thread. I got what I needed here. Thanks @TimHoolihan

Collectives™ on Stack Overflow

Mapping large string with Fluent NHibernate

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related