c# - Best practice to integrate existing MSSQL db into Umbraco? -

this general umbraco architectural question, not specific-to-the-line-of-code-question.

i new umbraco know way around .net , asp.net mvc well.

for upcoming project considering using umbraco cms experience umbraco little, cannot quite oversee options when comes integrating existing mssql database.

the database support umbraco installation has tables present, containing product information. best way expose data using umbraco api/models , subsequently integrate data in umbraco views?

e.g. can create data models in umbraco admin , map existing tables or there way considered best practice?

thank you.

i don't have lot of first hand experience subject did umbraco bootcamp covers this, it's called "umbraco application integration".

the course talks route hijacking , contentfinders mapping external data umbraco request pipeline.

to call external tables code, can umbraco's integrated lightweight orm called peta poco, little work entity framework or nhibernate can work.

to intergrate external tables umbraco backend, there's plugin called ui-o-matic out

hopefully puts on right track :)