Connect to Azure SQL database using managed identity C# .Net 6.0

Let's discuss the connecting .net 6.0 c# application to azure SQL serve using MSI

.NET 6.0 applications are more flexible and require less work than other.NET frameworks, such as.NET Core 3.1,.NET 4.8, and so on.

Connect  .Net Core 3.1 or the Lower version Application to azure SQL

  you will be using the following package

Install-Package Azure.Identity

Install-Package System.Data.SqlClient

Connect .Net 6.0 Application to Azure SQL: 

you will be using only following the NuGet package with the new connection string

dotnet add package Microsoft.Data.SqlClient

 if you are using system-assigned identity MSI then uses the following connections string and code.(Local Machine)

using Microsoft.Data.SqlClient;

...

// Uncomment one of the two lines depending on the identity type    

SqlConnection connection = new SqlConnection(

    "Server=tcp:<server-name>.database.windows.net;Database=<database-name>;

Authentication=Active Directory Default;TrustServerCertificate=True"

    ); // system-assigned identity

// Open the SQL connection

connection.Open();

If you are using a user-assigned identity then use the following connecting string or code (Local Machine)

using Microsoft.Data.SqlClient;

...

SqlConnection connection = new SqlConnection(

    "Server=tcp:<server-name>.database.windows.net;Database=<database-name>;

Authentication=Active Directory Default;

User Id=<client-id-of-user-assigned-identity>;TrustServerCertificate=True");

    // user-assigned identity

// Open the SQL connection

connection.Open();

Set up your dev environment and Visual Studio

• Visual Studio for Windows is integrated with Azure AD authentication. To enable development and debugging in Visual Studio, add your Azure AD user in Visual Studio by selecting File > Account Settings from the menu, and selecting Sign-in or Add.
• To set the Azure AD user for Azure service authentication, select Tools > Options from the menu, then select Azure Service Authentication > Account Selection. Select the Azure AD user you added and select OK

To run your application on Azure App Service, you may need to use the connection string below

Since Microsoft.Data.SqlClient 2.1.0, the driver supports authentication to Azure SQL Database, and Azure SQL Managed Instance by acquiring access tokens via managed identity. To use this authentication, specify either Active Directory Managed Identity or Active Directory MSI in the connection string, and no password is required. You can't set the Credential property of SqlConnection in this mode either.

Below connection string for system-assigned identity :

// For system-assigned managed identity

// Use your own server and database.

string ConnectionString1 = @"Server=demo.database.windows.net;

Authentication=Active Directory Managed Identity; Database=employeedb";

using (SqlConnection conn = new SqlConnection(ConnectionString1)) {

    conn.Open();

}

string ConnectionString2 = @"Server=demo.database.windows.net;

Authentication=Active Directory MSI; Database=employeedb";

using (SqlConnection conn = new SqlConnection(ConnectionString2)) {

    conn.Open();

}

For the other pre-steps of SQL server configuration, see here

Microsoft Graph API upload large file to SharePoint

How to Upload a file to SharePoint using Microsoft Graph API - C#/.Net?

To make it easier to upload large files, a number of entities in Microsoft Graph support plus some extra file uploads. Instead of attempting to upload the entire file in a single request, the file is divided into smaller pieces and a single request is used to upload a single slice. To make this process easier, the Microsoft Graph SDKs include a large file upload task that handles the uploading of the slices.

Azur AD Setup:

 you need to complete the following steps to configure the azure ad.

Step - 1: Register an application with the Microsoft identity platform

1. Sign in to the Azure portal.

2. If you have access to multiple tenants, use the Directories + subscriptions filter in the top menu to switch to the tenant in which you want to register the application.

3. Search for and select Azure Active Directory.

4. Under Manage, select App registrations > New registration.

5. Enter a Display Name for your application. Users of your application might see the display name when they use the app, for example during sign-in. You can change the display name at any time and multiple app registrations can share the same name. The app registration's automatically generated Application (client) ID, not its display name, uniquely identifies your app within the identity platform.

6.  see more here https://docs.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app

Step 2- Grand required permission to App

One of the following permissions is required to call this API. To learn more, including how to choose permissions, see Permissions.

you must have the below-highlighted permissions granted with Admin Consent 

Permission type	Permissions (from least to most privileged)
Delegated (work or school account)	Files.ReadWrite, Files.ReadWrite.All, Sites.ReadWrite.All
Delegated (personal Microsoft account)	Files.ReadWrite, Files.ReadWrite.All
Application	Files.ReadWrite.All, Sites.ReadWrite.All

Step-3:  Create secrete and save it (make sure to keep it secure)

When receiving tokens at a web addressable location, confidential applications can use credentials to identify themselves to the authentication service (using an HTTPS scheme). We recommend using a certificate (rather than a client secret) as a credential for greater assurance.

Step-4:  Get Client Id and Tenant Id

just get it and save it somewhere that will be later used in c# code.

C# Code  Setup

Step-1: Need to install the following NuGet pkg

• Azure.Identity
• Microsoft.Graph

Step-2:  Configuration setup

add the following configuration in the appsettings.json, but replace it with your own values that took in from the azure ad app.

"GraphAPISetting": {

  "ClientId": "d956647c-xxxx-xxxx-843b-56f0c7db967a",

  "ClientSecret": "VVe8Q~6Sk~xxxxxxxxqACB7xzxtZ0NEc2n",

  "TenantId": "33f294fc-00af-423d-XXXX-703cXXXXe3ed" 

}

Step-4: Finally C# code

private ClientCredentialProvider _SetAuthToken()

{

//_config - use microsoft configuration, dependecy injection.

   var _tenantId = _config["GraphAPISetting:TenantId"];

    var _clientId = _config["GraphAPISetting:ClientId"];

    var  _clientSecret = _config["GraphAPISetting:ClientSecret"];

    IConfidentialClientApplication confidentialClientApplication =

ConfidentialClientApplicationBuilder

        .Create(_clientId)

        .WithTenantId(_tenantId)

        .WithClientSecret(_clientSecret)

        .Build();

    return new ClientCredentialProvider(confidentialClientApplication);

}

public async Task<void> Upload()

{

   

    string site = "<YOUR DOMAIN, REPLACE HERE>.sharepoint.com";

    string relativePath = "/sites/<YOUR SITE, REPLACE HERE>";

var   _authProvider = _SetAuthToken();

    GraphServiceClient graphClient = new GraphServiceClient(_authProvider);

    Site s = await graphClient

        .Sites[site]

        .SiteWithPath(relativePath)

        .Request()

        .GetAsync();

    using (var fileStream =

        System

        .IO

        .File

        .OpenRead(

            @"myfile.txt"

        ))

    {

        var uploadSession = await graphClient

            .Sites[s.Id]

            .Drive

            .Root

            .ItemWithPath("sometext-1.txt")

            .CreateUploadSession()

            .Request()

            .PostAsync();

        // Max slice size must be a multiple of 320 KiB

        int maxSliceSize = 320 * 1024;

        var fileUploadTask =

            new LargeFileUploadTask<DriveItem>(uploadSession, fileStream,

maxSliceSize);

        var totalLength = fileStream.Length;

        // Create a callback that is invoked after each slice is uploaded

        IProgress<long> progress = new Progress<long>(prog => { });

        try

        {   // Upload the file

            var uploadResult = await fileUploadTask.UploadAsync(progress);

            //Console.WriteLine(uploadResult.UploadSucceeded ?

            //    $"Upload complete, item ID: {uploadResult.ItemResponse.Id}" :

            //    "Upload failed");

        }

        catch (ServiceException ex)

        {

            //Console.WriteLine($"Error uploading: {ex.ToString()}");

        }

    }

}

Final Output

 you will find that our text has been uploaded successfully.

Some useful reference 

https://developer.microsoft.com/en-us/graph/graph-explorer

https://docs.microsoft.com/en-us/graph/api/drive-get?view=graph-rest-1.0&tabs=csharp

azure function error unknown argument --port

How to run Azure Function app on a different port in Visual Studio

or 

azure function error unknown argument --port

How to Fix it?

• Update Project Properties -> Debug to following
• put the following command  "host start --port 7071 --pause-on-error"

Finally, it works 

flutter/Android WebView not loading an HTTPS or http URL

flutter/Android WebView not loading an HTTPS or http  URL

You can use the WebView plugin to display a webpage within your Flutter application. A Flutter plugin that provides a WebView widget.

Step 1:

Install web view using the following command 

•  flutter pub add webview_flutter

Step 2:

user android:usesCleartextTraffic="true" to run  HTTP sites. not require for  HTTPS websites

Step 3:

Final Code: You can use the following code to run the website under android

import 'package:flutter/material.dart';
import 'package:webview_flutter/webview_flutter.dart';

void main() {
  runApp(
    const MaterialApp(
      home: WebViewApp(),
    ),
  );
}

class WebViewApp extends StatefulWidget {
  const WebViewApp({Key? key}) : super(key: key);

  @override
  State<WebViewApp> createState() => _WebViewAppState();
}

class _WebViewAppState extends State<WebViewApp> {
  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: const Text('Flutter WebView'),
      ),
      body: const WebView(
        initialUrl: 'https://www.stackoverflowtips.com/',
      ),
    );
  }
}

Compile your code and have it run in an emulator:

sample output from code labs. developers. google. com

Bonus Point

You  may face the following issue "Android Webview gives net::ERR_CACHE_MISS message"

You can fix this issue by 

• go to AndroidManifest.xml
• add the following configuration
• <uses-permission android:name="android.permission.INTERNET" />
• Ensure that you don't have webView.getSettings().setBlockNetworkLoads (false);

What is a Non-fungible token?

 What is an NFT?

NFTs, or non-fungible tokens, are cryptographic tokens that exist on a blockchain but cannot be copied, each with its own unique identifying number and metadata.

NFTs are comparable to orators or information tokens, but they are neither interchangeable or fungible like cryptocurrencies like Bitcoin or Ethereum. NFT supporters claim that NFTs provide a public certificate of authenticity or proof of ownership, but the legal rights conveyed by an NFT are uncertain. The request of an NFT, as defined by the blockchain, has no inherent legal meaning and provides no other legal rights over the digital files associated with it.

A Non-fungible Token (NFT) is a digital asset, also known as a cryptographic asset, that has a unique identification code and metadata that distinguishes it from a fungible token. They, like cryptocurrencies, cannot be traded or exchanged at equivalent values. The difference between fungible tokens and cryptos is that cryptos are exactly the same and can thus be used for commercial transactions.

Some Famous and Most Expensive NFT

BORED APE YACHT CLUB

BAYC is a collection of 10,000 Bored Ape NFTs—unique digital collectibles living on the Ethereum blockchain. Your Bored Ape doubles as your Yacht Club membership card, and grants access to members-only benefits, the first of which is access to THE BATHROOM, a collaborative graffiti board. Future areas and perks can be unlocked by the community through roadmap activation.

BAYC Floor Price:  91.5 ETH

CryptoPunks (Ͼ)

CryptoPunks launched as a fixed set of 10,000 items in mid-2017 and became one of the inspirations for the ERC-721 standard. They have been featured in places like The New York Times, Christie’s of London, Art|Basel Miami, and The PBS NewsHour.

Floor Price: 47.45 ETH , famous nft:

How does NFT work?

NFTs rely on blockchain technology to function. Because of its unique construction, each NFT has the potential to be used in a variety of applications. A digital asset management platform is a great way to represent actual assets like real estate and artwork digitally. Because NFTs are constructed on blockchains, they can also act as identity management systems in addition to removing intermediaries and linking artists to audiences.NFTs can remove intermediaries, make transactions more efficient, and create new markets.

Many crypto-trading enthusiasts and art collectors use NFTs. Additionally, it can be used for digital content, gaming items, investment collateral, and domain names.

TOP 10 NFT as of now dated 10/JUN/2022

if you are interested in crypto try the below link you will get an awesome discount on brokerage 

Use my code for the great deals

Crypto exchanges You Can Join 

Bybit Exchange - referral code: JZBLL2 or   Click to Join

Kucoin Exchange - referral code: rBPQFWD or  Click to Join

Binance Exchange - Code: GW4QZ68E or click here to join Biance