title: Business Connectivity Services for a large scale database having several stored procedures
body: <p>I am working on a project having a large scale database with several stored procedures and I need to use the data in SharePoint 2013, the database is in SQL Server 2008 R2</p>
  
  <p>According to my understanding I have two options: </p>
  
  <p>1) is to create a Web service, using entity framework to interact with the database and most probably will use WebAPI. My logic will be in Stored procedures or DAL layer.</p>
  
  <p>2) Secondly, I did a little research and got to know about the Business connectivity services provided by the SharePoint 2010/2013 as I am working with 2013 so I will be using visual studio 2012. Now learning more about the BCS I understood that I can map each table as a content type and then somehow define relationship. Anwyay, implementing BCS is a separate issue which I think I will somehow manage.</p>
  
  <p>My question is how am I going to import/include my stored procedures? and if not stored procedures then where will I write my queries to get the data from the BCS?</p>
  
  <p>Please direct me to right direction. Thank you.</p>