Fluent NHibernate multiple table with the same schema

Question

I have 100 tables with the same schema. What is the best solution with Fluent NHibernate for this situation? I mean what mapping(s) I should create? Thanks in advance! See pict.:

enter image description here

PS. Every table contains a really huge amount of data.

PPS I need query to all that tables as if they are a single table. — Alexandr, Jul 25 '13 at 14:24
do you only need to read from those tables, or do you want to write data as well? — Cristian Lupascu, Jul 25 '13 at 14:40

score 1 · Accepted Answer · edited May 23 '17 at 12:21

1

If you ONLY want to map all the tables for reading purposes, you can do it creating an SQL view that performs a UNION ALL query over all your tables.

Then, just map your SQL view as you map a single table.

Take a look into this answer for a previous question (and similar too).

edited May 23 '17 at 12:21

Community

1
1

answered Jul 25 '13 at 15:12

HuorSwords

2,225
1
21
34

Fluent NHibernate multiple table with the same schema

1 Answers1