I am using Fluent Nhibernate with MSSql 2008 in an ASP.net MVC 3.0 project. 

```

private static ISessionFactory CreateSessionFactory()
        {
 FluentConfiguration configuration = Fluently.Configure()
     .Database(MsSqlConfiguration.MsSql2008
       .ConnectionString("Data Source=Comp;Initial Catalog=MyDB;Integrated Security=true")
       .ShowSql()).ExposeConfiguration(c => c.SetProperties(AddProperty()))
     .Mappings(m => m
       .FluentMappings.AddFromAssemblyOf());
       return configuration.BuildSessionFactory();
}

private static IDictionary  AddProperty()
        {
            IDictionary config = new Dictionary();
            config.Add("current_session_context_class", "web");
            config.Add(NHibernate.Cfg.Environment.ProxyFactoryFactoryClass, "NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle");
            return config;
        }

```

But, I am getting this error "Could not find the dialect in the configuration"