Menu
I would like to create a C# ASP.Net application and query (read-on) information from our companies SharePoint site. Is this possible and if so how?
733
Although SharePoint rests on a database management system and has some similar functionality, the platform itself is not a database. If all you need is just structured and secure storage for several thousands of documents, SharePoint can easily meet your needs.
On the Tools menu, click Data Connections. In the Data Connections dialog box, click Add. In the Data Connection Wizard, click Create a new connection to, click Submit data, and then click Next. Under How do you want to submit your data, click To a document library on a SharePoint site, and then click Next.
Create a connection to the external data Click Add Connection, select SQL Server in the External Data Source Type Selection dialog box, and then click OK. In the SQL Server Connection dialog box, enter the name of the server, the database name, an optional description, and then click OK.
The SharePoint Server 2016 application is built on the SQL Server database engine. Most content and settings in SQL Server 2014 (SP1), SQL Server 2016, and SQL Server 2017 RTM are stored in relational databases. The following table shows the databases that SharePoint Servers 2016 and 2019 use.
The best way for a standalone application to read data from a Sharepoint site from outside the farm is through Sharepoint Web Services. That page has a high-level summary of what services are available and what each one does. In Visual Studio, you can connect to these by creating Web References to the desired services in your application.
97
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
