Posts

Get Azure AD app-only access token using certificate on .NET Core

Get Azure AD app-only access token using certificate on .NET Core Communicating with SharePoint Online using an app-only access token is invaluable when building non-interactive applications. Here is how you can get an Azure AD app-only access token in .NET Core. SharePoint Online authentication protocols When building solutions for SharePoint, before you are allowed to communicate with SharePoint your application must authenticate with SharePoint. SharePoint Online supports two kinds of authentication protocols: one based on ACS, traditionally used by SharePoint add-ins, and one based on Azure Active Directory (AAD). The main difference between the two protocols is that the ACS-based protocol is specific to SharePoint and offers you access only to SharePoint APIs. On the other hand using the AAD-based protocol you can access resources from all Office 365, given your application has sufficient permissions. As a result, using the AAD-based authentication you can build more powerful solu...

GRANT SQL To SCHEMA

 -- Cấp quyền CONNECT cho user mới (GRANT) GRANT CONNECT TO test; -- Cấm quyền ALTER cho schema dbo đối với user mới (DENY) DENY ALTER ON SCHEMA::dbo TO test; -- Cấm quyền CREATE SEQUENCE cho schema dbo đối với user mới (DENY) DENY CREATE SEQUENCE ON SCHEMA::dbo TO test; -- Cấm quyền DELETE cho schema dbo đối với user mới (DENY) DENY DELETE ON SCHEMA::dbo TO test; -- Cấm quyền EXECUTE cho schema dbo đối với user mới (DENY) DENY EXECUTE ON SCHEMA::dbo TO test; -- Cấm quyền INSERT cho schema dbo đối với user mới (DENY) DENY INSERT ON SCHEMA::dbo TO test; -- Cấm quyền REFERENCES cho schema dbo đối với user mới (DENY) DENY REFERENCES ON SCHEMA::dbo TO test; -- Cấm quyền TAKE OWNERSHIP cho schema dbo đối với user mới (DENY) DENY TAKE OWNERSHIP ON SCHEMA::dbo TO test; -- Cấm quyền UPDATE cho schema dbo đối với user mới (DENY) DENY UPDATE ON SCHEMA::dbo TO test; -- Cấm quyền VIEW DEFINITION cho schema dbo đối với user mới (DENY) DENY VIEW DEFINITION ON SCHEMA::dbo TO test; -- Cấm quyền VI...

Bulk Insert Update in C# using Stored Procedure

Image
 Nguồn:  Bulk Insert Update in C# using Stored Procedure - Dot Net Tutorials Bulk Insert Update in C# using Stored Procedure Back to:  ADO.NET Tutorial For Beginners and Professionals Bulk INSERT and UPDATE in C# and ADO.NET using Stored Procedure In this article, I am going to discuss  How to Perform BULK INSERT and UPDATE in C#  and ADO.NET using SQL Server Stored Procedure with Examples. Please read our previous article where we discussed  ADO.NET Architecture . Here, in this article, I will explain to you how to perform the Bulk Insert and Update using the Stored Procedure with Examples, and in the next article, I am going to discuss how to Perform Batch Operations Using SqlBulkCopy and DataAdapters. Advertisements × Bulk Insert and Update using Stored Procedure and C# ADO.NET: Let us understand how to perform Bulk Insert and Update using C# and ADO.NET. So, basically what we will do is, we will check if the record does not exist in the database, then w...