Fluent NHibernate Database First Configuration

Question

I am new to Fluent Nhibernate. We have started using it for a Back office application for Data Access.

The client already has a Database with them so we would like to use the Database first approach as we don't want to generate tables.

For a Proof of concept solution, I used the below Session Factory configuration

var oracleConfiguration = OracleDataClientConfiguration.Oracle10.ConnectionString("Data Source=MyDB;User Id=MyUserName; Password=myPassword; Pooling=true");
        return Fluently.Configure()
                       .Database(oracleConfiguration)
                       .Mappings(m => m.FluentMappings.Add<NhtestMap>())
                       .ExposeConfiguration((config) => { new SchemaExport(config).Create(false, true); })
                       .BuildSessionFactory();

Since I already have this table in my DB before running this code, the method 'ExposeConfiguration' has dropped the test table 'NHTest'.

I read few blogs and came to know that this method creates table on first run (Which is the required behavior for Code First approach). But for us, with the DB First approach, we don't want to drop or create tables.

Can some one please help me out to correctly configure the Session Factory for DB First approach ?

remove the line .ExposeConfiguration(...)

Fran
– Fran

2017-04-06 13:38:17 +00:00
Commented Apr 6, 2017 at 13:38 — Fran
– Fran, Commented Apr 6, 2017 at 13:38

Dai Bok · Accepted Answer · 2017-10-19 12:53:23Z

2

Try this:

var oracleConfiguration = OracleDataClientConfiguration.Oracle10.ConnectionString("Data Source=MyDB;User Id=MyUserName; Password=myPassword; Pooling=true");
        return Fluently.Configure()
                       .Database(oracleConfiguration)
                       .Mappings(m => m.FluentMappings.Add<NhtestMap>())
//  Remove this line //.ExposeConfiguration((config) => { new SchemaExport(config).Create(false, true); })
                       .BuildSessionFactory();

answered Oct 19, 2017 at 12:53

Dai Bok

3,6763 gold badges60 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Fluent NHibernate Database First Configuration

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related