title: 'table per subclass' or 'table per class hierarchy'
body: <p>I am using FNHibernate and its default is 'table per subclass' for inheritance mapping. This seems to be the cleanest way to do things but it has its downsides too. My problem is that I have to seed the database with lots of  tab separated data. I have tried to do this via repositories/services (i.e. via FNHibernate) but this is very slow so I switched to SQL:</p>
  
  <p><a href="https://stackoverflow.com/questions/3289865/insert-data-into-several-tables-possibly-using-output-sql-server-2005">insert data into several tables - possibly using OUTPUT - sql server 2005</a></p>
  
  <p>I am currently using loops to seed the database but this takes ages. I am just wondering whether there are faster ways to seed a 'table per subclass’ type database or do I have to switch to 'table per class hierarchy' mapping?</p>
  
  <p>I am sure that other people must have encountered the same problem. Any feedback is very much welcome. Many thanks in advance!</p>
  
  <p>Best wishes,</p>
  
  <p>Christian</p>