sharepoint db connection

Normally SharePoint DB concept is different. Here we use list and library to save or retrive data/files. In some case, we can use DB with tables or other db facilites, such case you can use normal conection as other web appliation (conn str: use sql server authentication).

For SharePoint list/library: 

- Use SPMetal class (Like linq to list/library) similar to linq. http://www.c-sharpcorner.com/UploadFile/a9d961/spmetal-in-sharepoint-2013/

- Use CAML query (google CAML for sharepoint list)

- http://www.dotnetcodesg.com/Article/UploadFile/2/216/CRUD%20(Create%20Read%20Update%20Delete)%20Operations%20on%20a%20SharePoint%20List%20programmatically.aspx

https://www.layer2solutions.com/en/products/Pages/SharePoint-Integration-BDLC-Use-Cases.aspx?gclid=CPCikruo29QCFdWFaAod49wHtA

 

http://www.fastsharepoint.com/ 

 

https://www.youtube.com/watch?v=i5sIi894D7E&list=PLx54OR2-wapVJ5fm7364DRFS_MTBr5Hhv