sharepoint db connection

Question

Hi Iam share point beginner.i have some queries based on db connection and how to show db value to frontend

Mani Kandan · Answer

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

Rijwan Ansari · Answer

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

Rajkiran Swain · Answer

https://support.office.com/en-us/article/Publish-a-database-to-a-SharePoint-site-8287ed04-9c65-46c4-bbdb-c965c56b018c?ui=en-US&rs=en-US&ad=US&fromAR=1