How to read SharePoint Data and insert into SQL

Thanks Jithu Thomas
As you suggested i have tryed and it is working 

Install Required Libraries:

You will need to install the necessary libraries for SharePoint connectivity and SQL Server connectivity in your C# project. These libraries can be added through NuGet if they are not already included:

Microsoft.SharePoint.Client: for SharePoint connectivity.
System.Data.SqlClient: for SQL Server connectivity.

Connect to SharePoint:

Connect to your SharePoint site using the SharePoint Client Object Model. Here's a basic example of how to establish a connection:

using Microsoft.SharePoint.Client;

string siteUrl = "https://your-sharepoint-site-url";
string username = "your-username";
string password = "your-password";

using (ClientContext context = new ClientContext(siteUrl))
{
    context.Credentials = new SharePointOnlineCredentials(username, Utilities.CreateSecureString(password));
    
    // Perform SharePoint operations here
}
 

Read SharePoint Data:
Use the SharePoint Client Object Model to retrieve the data you need from SharePoint. This can involve fetching lists, items, or documents, depending on your requirements.

List spList = context.Web.Lists.GetByTitle("YourListName");
CamlQuery query = CamlQuery.CreateAllItemsQuery();
ListItemCollection items = spList.GetItems(query);
context.Load(items);
context.ExecuteQuery();

foreach (ListItem item in items)
{
    // Extract data from SharePoint item
    string columnValue = item["ColumnName"].ToString();
    
    // Insert this data into SQL Server
}
 

Connect to SQL Server:
Establish a connection to your SQL Server database, as described in the previous answer.

Insert Data into SQL Server:
Use SQL commands to insert the data retrieved from SharePoint into your SQL Server database. You can use parameterized queries to ensure data integrity and security.

string sqlConnectionString = @"Server=YourSqlServer;Database=YourDatabaseName;Integrated Security=true;";
using (SqlConnection sqlConnection = new SqlConnection(sqlConnectionString))
{
    sqlConnection.Open();

    // Inside the SharePoint data retrieval loop
    string insertQuery = "INSERT INTO YourTableName (Column1, Column2, ...) VALUES (@Value1, @Value2, ...)";
    using (SqlCommand insertCommand = new SqlCommand(insertQuery, sqlConnection))
    {
        insertCommand.Parameters.AddWithValue("@Value1", columnValue1); // Use SharePoint data
        insertCommand.Parameters.AddWithValue("@Value2", columnValue2); // Use SharePoint data
        // Add parameters for all columns in your table

        insertCommand.ExecuteNonQuery();
    }
}

Close Connections:
Make sure to close both the SharePoint and SQL Server connections when you're done.