I am getting into more detail with my advances in MVC and started out using
the entity framework to build repositories and contexts for intefacing with
data in my SQL Server database.
Previous to this I coded my own SQL using the SQL command namespacess and
some data adapters instantiating objects to implement them in data class
I am also using LINQ now and have been able to handle everything using it.
The other day I starting getting into data requests that I would normally
have used subselects with lists or more complex joins with other tables.
I was wondering if those that have been using MVC find it normal to mix the
built in entity framework database interfaces with their own SQL in SQL commands
or stored procdures as they see fit or should one approach be used only?