Build ASP.Net Core Razor Page Application

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

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

Prerequisites,

  • 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.

1

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,

4.PNG

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

5

 

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.

6

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.

7

 

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.

8.PNG

Advertisements

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> { “udara@udaradevlab.onmicrosoft.com” };
emailprpoperties .To = new List<string> { “udara@udaradevlab.onmicrosoft.com” };
emailprpoperties .From = “testuser@udaradevlab.onmicrosoft.com”;
emailprpoperties .Body = “<b>Hi Udara, You receive a test Mail</b>”;
emailprpoperties .Subject = “Mail Testing”;

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

 

Thanks,

Udara

Create a webpage using HTML and CSS