I have has a look at this and it should work without any changes to Cuyahoga. You should be able to use it within the context of a module.
The mappings are generated using T4 templates in a separate project within the same solution. This process is instant. Drag and drop the tables into a LINQ to SQL class and the T4 generates the mapping. Any changes to the database are reflected immediately (you just delete the table from the LINQ to SQL class and add the altered table). At the moment there is still a cut and paste into the web project domain. This step can be removed with some polish and a build event to copy/rename them.
The good thing is that if the mapping is incorrect then it will not build. They are also a lot less noisy.
I managed to dump some database info into a gridview really quick like this ( this is only a test
).
Code:
private ISessionFactory _SessionFactory;
private ISession _Session;
private static ISessionFactory CreateSessionFactory()
{
return Fluently.Configure()
.Database(
MsSqlConfiguration.MsSql2005
.ConnectionString( c =>
c.FromConnectionStringWithKey( "connectionString" ))
)
.Mappings( m =>
m.FluentMappings.AddFromAssemblyOf (nc_Catalog) ()
)
.BuildSessionFactory();
}
protected void Page_Load(object sender, EventArgs e)
{
this._SessionFactory = CreateSessionFactory();
this._Session = _SessionFactory.OpenSession();
string hql = "select c from NHTests.Domain.nc_Catalog c";
IQuery q = _Session.CreateQuery(hql);
q.List();
GridView1.DataSource = q.List();
GridView1.DataBind();
...etc
}