Is there way to append custom SQL to the SQL generated from the Entity Framework. The reason I am asking is because an ERP system that I am working with requires some underlying SQL to be called before you can execute any Select/Insert/Update statements.
Right now all database interactions are done via stored procedures which I can continue to use going forward, but I could reduce the number of stored procedures I have to maintain if I can append a basic SQL statement before the SQL generated from the Entity
Framework.
For example say Entity framework creates this SQL statement:
Select FirstName From Customer;
However I need it to generate SQL like this
##Custom SQL Statement##;
Select FirstName From Customer;
Without first executing the Custom SQL Statement first, the select statement won't work. This a requirement by the ERP system when executing SQL against it.
Thanks for Your Help
Brian