Fluent nhibernate configuration error using web.config

Question

Hi im new in fluent nhibernate: I get an error when configure db conection using web.config The error is "An invalid or incomplete configuration was used.."

Web.config:

    <connectionStrings>
       <add name="Connection1" providerName="System.Data.SqlClient"
        connectionString="Server=local;Database=aDataBase;User ID=aUser;Password=***;Trusted_Connection=False;"/>

My fluent configuration:

_sessionFactory = Fluently.Configure()
  .Database(MsSqlConfiguration.MsSql2008
        .ConnectionString(c => c.FromConnectionStringWithKey("Connection1")).ShowSql() )
        .Mappings(m =>m.FluentMappings.AddFromAssemblyOf<Car>())
            .BuildSessionFactory();

It works if I use

   .ConnectionString(@"Server=local;Database=aDataBase;User ID=aUser;Password=***;Trusted_Connection=False;"

but I want to get the connection string from Web.config (not Hard-coded).

thanks.

your solution works for me, you probably have problem elsewhere, try checking inner exception. — mentat
– mentat, Commented Nov 30, 2011 at 16:36
Something like this should work:-.ConnectionString(ConfigurationManager.ConnectionStrings["Connection1"].ConnectionString) — Nick Ryan
– Nick Ryan, Commented Dec 20, 2011 at 17:02

Rafael Leites Luchese · Accepted Answer · 2015-11-08 22:52:48Z

2

Try using the ConfigurationManager object to acces your connection string. Something like this should work:

_sessionFactory = Fluently.Configure()
    .Database(MsSqlConfiguration.MsSql2008
    .ConnectionString(ConfigurationManager.ConnectionStrings["Connection1"].ConnectionString).ShowSql())
    .Mappings(m =>m.FluentMappings.AddFromAssemblyOf<Car>())
    .BuildSessionFactory();

answered Nov 8, 2015 at 22:52

Rafael Leites Luchese

897 bronze badges

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

Collectives™ on Stack Overflow

Fluent nhibernate configuration error using web.config

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