How to export hbm xml files using s#arparchitecture with fluent mappings

Question

This question was asked before but the answers all show how to export the hbm files from fluentnhibernate. We are using S#arpArchitecture which wraps fluent. I am able to export the schema but what I really want is the xml files to troubleshoot errors. I've done this using FNH before but adding S#arp to the mix has complicated things where I cannot figure it out.

I've found this question asked on several forums, but I can't find one that shows how to get the mapping files.

score 4 · Accepted Answer · answered Jul 25 '10 at 00:41

Here is how I do it in one of my projects:

[TestMethod]
    public void CreateSchema()
    {
        var mappingOutput = ConfigurationManager.AppSettings["xmlMappingOutputDirectory"];
        var sqlOutput = ConfigurationManager.AppSettings["sqlOutputDirectory"];

        Configuration cfg = new Configuration().Configure();
        var persistenceModel = new PersistenceModel();
        persistenceModel.AddMappingsFromAssembly(Assembly.Load("ProjectName.Data"));
        persistenceModel.Configure(cfg);
        persistenceModel.WriteMappingsTo(mappingOutput);
        new SchemaExport(cfg).SetOutputFile(sqlOutput).Create(true, false);
    }

You will need to set the two keys in the your app config or provide values directly for them.

Thanks, What namespace do I need for Configuration cfg = new Configuration().Configure(); — Maggie, Jul 25 '10 at 01:54

score 0 · Answer 2 · answered Jun 08 '12 at 16:24

As it turns out that only works if you're not using automapping. Here's the solution if you're using automapping:

public void CanGenerateMappingFiles() 
{ 
    DirectoryInfo directoryInfo = new DirectoryInfo("../../../../db/mappings"); 

    if (!directoryInfo.Exists) 
        directoryInfo.Create(); 

    Configuration cfg = new Configuration().Configure();  
    var autoPersistenceodel = new AutoPersistenceModelGenerator().Generate(); 

    autoPersistenceodel.Configure(cfg); 
    autoPersistenceodel.AddMappingsFromAssembly(Assembly.Load("TrackerI9.Data")); 
    autoPersistenceodel.WriteMappingsTo(directoryInfo.FullName); 
}

You'll have to make sure that your configuration is set up correctly and that you choose an appropriate location for the directory, but otherwise this should work. It did for me.

score 0 · Answer 3 · answered Feb 14 '11 at 09:37

0

http://wiki.fluentnhibernate.org/Fluent_configuration#Exporting_mappings

In the Mappings call, you can do the following:

.Mappings(m =>
{
  m.FluentMappings
    .AddFromAssemblyOf<YourEntity>()
    .ExportTo(@"C:\your\export\path");

  m.AutoMappings
    .Add(/* ... */)
    .ExportTo(@"C:\your\export\path");
})

answered Feb 14 '11 at 09:37

Igor Zelmanovich

829
10
6

Thanks for your answer, but I could not use this method, which I linked to in my original question, which is why I asked the question. Alec answered the question for how to do the export within the Sharp architecture framework. – Maggie Feb 17 '11 at 16:53

How to export hbm xml files using s#arparchitecture with fluent mappings

3 Answers3