FluentNHibernate SQL Server configuration; connectionstring problem

Question

It's my first attempt on Fluent NH. I store the connection string in Properties.Settings;

FnhDbString = Data Source=PC\SQLEXPRESS;Initial Catalog=FNHTest;Integrated Security=True

If I configure Fluent with .FromAppSetting I get exception:

ArgumentNullException
Value cannot be null. Parameter name: Data Source

If I configure Fluent with .FromConnectionStringWithKey I get exception:

NullReferenceException
Object reference not set to an instance of an object.

The full method:

private static ISessionFactory CreateSessionFactory()
{ 
      return Fluently.Configure()
        .Database(MsSqlConfiguration.MsSql2008
        .ConnectionString(c => c
            .FromAppSetting(Properties.Settings.Default.FnhDbString))
        .Cache(c => c
            .UseQueryCache()).ShowSql())
        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<Product>())
        .BuildSessionFactory();
}

...

So what am I doing wrong here..?

Yogesh · Accepted Answer · 2011-01-27 09:17:25Z

7

Change this:

.ConnectionString(c => c.FromAppSetting(Properties.Settings.Default.FnhDbString))

to this:

.ConnectionString(Properties.Settings.Default.FnhDbString)

answered Jan 27, 2011 at 9:17

Yogesh

14.6k6 gold badges47 silver badges72 bronze badges

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

2 Comments

Adam Over a year ago

I'm curious why this worked? I have a similar problem using the lamba syntax that apparently doesnt work? Trying to use the ConnectionStringFromKey method

Yogesh Over a year ago

That worked because FromAppSetting needs a appSetting key value which you can access using ConfigurationManager.AppSettings["key"];. Secondly, he was directly passing the value of the key FnhDbString from resources, i.e. the connection string, to the FromAppSetting method, which obviously fails. Just passing the connection string directly to the parent method words without issues.

Collectives™ on Stack Overflow

FluentNHibernate SQL Server configuration; connectionstring problem

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related