Build ASP.Net Core Razor Page Application

In this post, I’m going to show how to build Core Web Application with Razor Pages.

Razor Pages is a new aspect of core MVC, Razor pages make a coding page focused approach to develop web applications.


  • Visual Studio.
  • .net Core SDK.

Let’s move to project set up,

Step 01,

  • From the Visual Studio File menu, select New > Project.
  • Create a new ASP.NET Core Web Application. Name the project Store.


Step 02,

  • Select ASP.NET Core 2.1 in the drop-down, and then select Web Application.2
  • Then Visual studio template creates a Razor Project.3
  • After Successfully creates the project you can run it.

Step 03,

Now we are going to Connect with Database using Razor App,

We are going to implement App using Entity Framework DB Approach.

To use EF Core, install the package for the database provider(s) you want to target. This walkthrough uses SQL Server. For a list of available providers see Database Providers.

  • Tools > NuGet Package Manager > Package Manager Console
  • Run Install-Package Microsoft.EntityFrameworkCore.SqlServer

We will be using some Entity Framework Tools to create a model from the database. So we will install the tools package as well:

  • Run Install-Package Microsoft.EntityFrameworkCore.Tools

We will be using some ASP.NET Core Scaffolding tools to create controllers and views later on. So we will install this design package as well:

  • Run Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design


Create a Database Called “StoreDB” & then Create a table called “Product” with following columns,


Then create the Entity Framework model based on your existing database.

  • Tools –> NuGet Package Manager –> Package Manager Console
  • Run the following command to create a model from the existing database:

Scaffold-DbContext “Data Source=295_LP1\SQLEXPRESS2012;Initial Catalog=StoreDB;User ID=sa;Password=123” Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models



Step 04,

  • In Solution Explorer, right-click on the Pages folder > Add > New Folder.
  • Name the folder Movies

In Solution Explorer, right-click on the Pages/Movies folder > Add > New Scaffolded Item.


Complete the Add Razor Pages using Entity Framework (CRUD) dialog:

  • In the Model class drop down, select Movie (Store.Models).
  • In the Data context class row, select the + (plus) sign and accept the generated name Store.Models.StoreDBContext.
  • In the Data context class drop down, select Store.Models.StoreDBContext
  • Select Add.



To register as a service, open Startup.cs, and add the highlighted lines to the method.

public void ConfigureServices(IServiceCollection services) { services.AddDbContext<StoreDBContext>(options => options.UseSqlServer(Configuration.GetConnectionString(“DefaultConnection”))); services.AddMvc(); }

Open the appsettings.json file and add a connection string as shown in the following code:

“ConnectionStrings”: {
“DefaultConnection”: “Data Source=295_LP1\\SQLEXPRESS2012;Initial Catalog=StoreDB;User ID=sa;Password=123”
“Logging”: {
“LogLevel”: {
“Default”: “Warning”
“AllowedHosts”: “*”


Now run your project,

Then you can do CRUD operations with Razor Web APP.



Build MVC Project with Oracle Data Base using Entity Framework DB first approach

In this article i want to explain how to create MVC Application with Oracle Database using Entity Framework DB first approach.

first you have to install visual studio, i’m going to demonstrate using Visual Studio 2015, because at the moment Oracle  provided Oracle Developer tools for Visual  Studio up to visual studio 2015 version. then you have to install Oracle Data base in your local machine or you can access remote Oracle DB.

you can download Oracle Developer tools using this Link

After successfully installing Visual Studio and Oracle Developer tools (ODT), lets go to steps ,

Step 01

Open Visual Studio and Create Empty MVC Project.

Step 02

Then you have to install Oracle Managed DataAccess and Oracle Managed DataAccess Entity framework packages using Nuget package manager to your Project.

after successfully installing Oracle Packages you can see those packages inside the references.

Step 03

Then you have to connect oracle Connection to Visual Studio Data Connections by Providing Oracle Connection Properties.

Step 04

Then add model to your project, in this process you  have select your connection and Database properties such as Tables , Views etc.

After that it will create Database Context and model entities in side your project.then you will see the Model entity classes inside your project.

Step 05

Then you have to provide password for Web Config connection String, because in Context and Model Generating process it will not provide password for your connection string.


Step 06

Now Almost done, you can call Database and Retrieve Values from Database.

i have create new controller and Access connected database using Context (Entities).



Note : if you get Exception like below while run the application ,

Type is not resolved for member ‘Oracle.ManagedDataAccess.Client’

you have register you oracle Manage data access in Global Assembly Cache (GAC).

Below is the Steps of Register Oracle Managed Data Access in GAC.

Set Path to Oracle Managed Data Access stored in :

C:\Windows\system32>cd E:\ud\packages\Oracle.ManagedDataAccess\

then Run Below command to add GAC

E:\ud\packages\Oracle.ManagedDataAccess\>”C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools\gacutil.exe” /i Oracle.ManagedDataAccess.dll

if Successfully Added to GAC you will see below messege in CMD,

Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.33440
Copyright (c) Microsoft Corporation.  All rights reserved.

Assembly successfully added to the cache




Error: Microsoft Report Viewer item (RDLC) not available to add in Visual Studio 2017

Hi all,

I got this problem when i’m working with Visual Studio 2017. i had requirement to add Microsoft Report Viewer (RDLC) file to my project, but when i go to add new item , there is no any reporting component to add to project.

I do three ways to resolve this issue.,

First :

Run the Visual Studio 2017 Setup file and check SQL Server Data Tools installed or Not.if not please install it.



Install  Microsoft Repo,rt Projects for Visual Studio using below link

Microsoft Report Projects for Visual Studio

after install the Microsoft Report Projects for Visual Studio you can use reporting as separate project.

you can add report project into solution under Business Intelligence category.


Third :

Install Microsoft Rdlc Report Designer for Visual Studio using below link

Microsoft Rdlc Report Designer for Visual Studio

After install Microsoft Rdlc Report Designer,you can add Microsoft Report Viewer File (RDLC) to your project.


If is there any Issue with above steps, feel free to contact me,





Happy Coding !

Visual Studio 2017 Offline Installer

Hi Guys,

Visual studio 2017 offline installer not available in Visual Studio Official Site,there is only online installer for here i have Shared link for Visual Studio 2017 Offline Installer,

Link :

Zip password : UdaraDev2017

if is there any issue with installer, please let me know.

Happy Coding !


Send Email in SharePoint Online Using SharePoint Client Object Model (CSOM)

HI, Below i have figured how to send Email in SharePoint Online using  SharePoint Client Object Model (CSOM).

In this case i have used “Microsoft.SharePoint.Client.Utilities”

This is a commonly used method to send email. You can use a SharePoint Utility class to send an Email. One downside is that you cannot send to external users. If you are sending to external users they should be added to your mail exchange.  That needs to be done in advance since it will take some time to reflect such changes.

Below is the Simple Code,

using (var EmailclientContext = clientContext)
 var emailprpoperties = new EmailProperties();
emailprpoperties .BCC = new List<string> { “” };
emailprpoperties .To = new List<string> { “” };
emailprpoperties .From = “”;
emailprpoperties .Body = “<b>Hi Udara, You receive a test Mail</b>”;
emailprpoperties .Subject = “Mail Testing”;

Utility.SendEmail(EmailclientContext , emailprpoperties );
EmailclientContext .ExecuteQuery();




ASP.NET Form Control Validation using Java Script and JQuery : Validate DropDown List in side the Grid View

Here i would like to explain how to validate Drop Down List in side the Grid View,It’s very Simple.

var GridView = document.getElementById(‘<%=Grid.ClientID %>’);

var DropDownArray = new Array();

for (var i = 0; i < DropDownArray .length; i++) { //Looping Dropdown list Array to validate
if (DropDownArray .item(i).value == ‘Pending’) //If dropdown has no selected value
//Put Validation Message
return false;


Create Simple SharePoint Provider Hosted App with Microsoft Azure

This explains you to how to create SharePoint Provider Hosted App with Microsoft Azure,


  1. Office 365 site (you can create Free trial site from Microsoft).Create Office 365 Account
  2. Microsoft Azure Account ( you can create free trial account from Microsoft).Create Azure Account
  3. Microsoft Visual Studio 2013 or 2015 (I’ll explain with 2013).

Step 01.

Start a new Visual Studio Project, use the “App for SharePoint 2013” template as in the following list.


Step 02.

Select the Provider-hosted option for this example. In a Provider-hosted app, application resources will be deployed in a server outside the SharePoint environment.Enter Your SharePoint office 365 site as Debugging App.


Step 03.

Select the type of web project you want to Host.I select “ Web form Application”,this step is most related to development architecture.(Ex. Tiered Architecture or MVC) .


Step 04 

In the next step, select “Use Client secret (requires a SharePoint farm connected to ACS)”. We will be using the Access Control Service (ACS) available with Microsoft Azure for this example.Simply Access between Hosted Account (Azure).



Step 05.

Click “Finish” and the project is created for you by Visual Studio. You can see two projects created under the solution. The first project consists of just an app icon and AppManifest.xml that manages all the settings like start URL, permission, Query strings, Client ID, Tokens and so on.6

Step 06.

The next step is to register a new app using client Id and Client Secret.

  • Go to the “/_layouts/15/appregnew.aspx” page of your SharePoint site (in my case, it is to generate the client Id and client secret id,
  • Click on the generate buttons of Client Id and Client Secret to generate both.


Step 07.

We need to fill in “App Domain” and “Redirect URL”. In fact, this is the website where the app is hosted. I am using Microsoft Azure to host my app. Let us go to the Windows Azure Management Portal and create a web site to host your app.


Step 08.

This the Web Site I have creted on Azure and credted Azure Site Details.



Step 09.

Enter Azure Site details on SharePoint App Registration form and press create button, then you will see App Identifier created message.


Copy the Client Id and Client Secret to a safe place.


Step 10.

The next step is to publish both projects separately. First, publish the app project as in the following


Enter Client Id and Client secret in below form and click finish.


Step 11.

Click Package your App,then you have to enter Azure Web site url and Client Id. After that Packed App file folder will open as below sreens.


Enter Url of Azure Web Site.


App file folder Location



Step 12.

Upload App File to SharePoint Site. You Should upload App file to Developer Site not a Team Site. Go How to Create Developer Site

  • Click New App To Deploy.


  • Then it’ll pop up App upload Panel


  • Click on Upload link and Upload you packaged App solution.


  • After successfully uploaded it’ll pop-up below screen,then press deploy button.


  • Now You can see your App on Site contents.


Step 13.

Click on App it’ll become server error , because we haven’t deployed the remote web to Microsoft Azure. The next step is to deploy the web app to Azure.


Step 14.

Publish the application to Microsoft Azure. Open web.config and update the client ID and Client secret as in the following


Step 15.

Then Publish the Web Solution to Azure, You can download Publish Profile settings from Azure Web site Setting.


Step 16.

After Successfully published you can retrieve Azure Web Site.

 Step 17.

Finally you click on app on SharePoint you can see app works as below.


Another thing get basic idea about App configuration from “AppManifest.xml”,Ex. App Startup page.