What’s New in Entity Framework Core 2.0

Posted on Updated on

Entity Framework Core is a lightweight, extensible, and cross-platform version of the popular Entity Framework data access technology. In this session we’ll look at what’s new in EF Core 2.0 and what the team has planned for upcoming releases.

Video:

https://channel9.msdn.com/Events/dotnetConf/2017/T221/player

 

Advertisements

How to set and get the session value in asp.net core.

Posted on Updated on

The Microsoft.AspNetCore.Session package provides middleware for managing session state.

  1. Add the following heightened line in your Startup.cs

public void ConfigureServices(IServiceCollection services)
{
services.AddMvc();
// Adds a default in-memory implementation of IDistributedCache
 services.AddDistributedMemoryCache();
services.AddSession(options =>
{
// Set a time for session
options.IdleTimeout = TimeSpan.FromSeconds(200);
options.Cookie.HttpOnly = true;
});
}

public void Configure(IApplicationBuilder app)
{
app.UseSession();
app.UseMvcWithDefaultRoute();
}
  1. Following line of code is needed to set the session value.

public class HomeController : Controller
{
const string SessionStoreName = "_StoreName";
const string SessionStoreID = "_StoreID";

public IActionResult Index()
{
// Requires using Microsoft.AspNetCore.Http
 HttpContext.Session.SetInt32(SessionStoreID, 3);
 HttpContext.Session.SetString(SessionStoreName, "ABC Store");
return RedirectToAction("SessionStore");
}
  1. To get the session value

public IActionResult SessionStore ()
{
var storename = HttpContext.Session.GetString(SessionStoreName);
var storeID = HttpContext.Session.GetInt32(SessionStoreID);
return Content($"Store Name: \"{ storename }\",Store ID: \"{ storeID}\"");
}

Rijwan Ansari

The Microsoft.AspNetCore.Session package provides middleware for managing session state.

  1. Add the following heightened line in your Startup.cs
  1. Following line of code is needed to set the session value.
  1. To get the session value

View original post

How to Restore the deleted/quarantined items by Windows Defender?

Posted on

Rijwan Ansari

Sometimes Windows Defender can detect your custom app, .exe file or other files as a threat and might have been deleted by the defender. If you want to restore it back here are some steps to follow.

Steps:

  1. Open the Windows Defender, you can directly open by typing Windows Defender Security Center in the search.

2. After opening, Click on Virus and Threat Protection.1.

3. Look on Scan History, there you can see the Quarantined threats.

2

4. Go to that Quarantined threats, select the quarantined items, to restore click restore option and for removal click on remove option.

5. To see the full history of Quarantined items, click on See Full History

In this way, you can restore or remove your quarantined items from windows defender security center.

For the proactive defense or to exclude your apps, files, and folders not to scanned by Windows Defender, there is an Exclusions option…

View original post 167 more words

Searchable Dropdown in SharePoint /ASP.NET

Posted on Updated on

As we know that default dropdown list is not searchable. Simple way to create searchable in asp.net/SharePoint solution.

Problem:

01

Resolution: ( Converting simple dropdown list to searchable )

02

Add following CSS link in the page:

    <link href="Content/choosen/docsupport/style.css" rel="stylesheet" />
    <link href="Content/choosen/docsupport/prism.css" rel="stylesheet" />
    <link href="Content/choosen/chosen.css" rel="stylesheet" />

Add Following script link in page:

  <script src="Scripts/jquery-1.10.2.js"></script>
  <script src="Content/choosen/chosen.jquery.min.js"></script>
  <script src="Content/choosen/docsupport/prism.js"></script>
  <script src="Content/choosen/docsupport/init.js"></script>

To change any dropdown list to searchable dropdown list:

Add “chosen-select” class to dropdown control.

   <div>
  <asp:DropDownList ID="ddltest" class="chosen-select form-control" data-placeholder="Choose a Country..."   runat="server">
                                <asp:ListItem></asp:ListItem>
                                <asp:ListItem>rijwan</asp:ListItem>
                                <asp:ListItem>satya</asp:ListItem>
                                <asp:ListItem>test</asp:ListItem>
                                <asp:ListItem>VS</asp:ListItem>
                                <asp:ListItem>OAD</asp:ListItem>
                                <asp:ListItem>ASD</asp:ListItem>
                                <asp:ListItem>My Request</asp:ListItem>
                                <asp:ListItem>reports</asp:ListItem>
                            </asp:DropDownList>
                        </div>

 

Necessary css and js file: Download

More details: Click Here !!

SharePoint Future : Roadmap to the Future of SharePoint

Posted on Updated on

“The Future of SharePoint is Bright,” says Seth Patton, General Manager for SharePoint and OneDrive.  This was the overarching theme in a 110-minute live online event made by Patton and Jeff Teper, Corporate Vice President, SharePoint and OneDrive, May 4th in San Francisco.

Aside from describing their passion and commitment to the SharePoint ecosystem, this presentation shared a lot of information about SharePoint Server on-premises and the future development of SharePoint Online as part of Office 365.

May 4, 2016, marked the general availability of SharePoint Server 2016.  While this announcement was not a big surprise to attendees and viewers from around the globe, what followed can only be described as a pivot in the trajectory of SharePoint and Office 365 as we currently know it.  It was no surprise that the focal point of the conversation was Office 365 and the re-branding of what we consider SharePoint sites within the cloud hosted offering.

Watch Future Of SharePoint

The conversation was structured into four pillars that define the make-up of the future of SharePoint:

  • Simple File Sharing – A common user interface for document libraries in OneDrive for Business and SharePoint is introduced, along with further integration linking document management using OneDrive or SharePoint almost synonymously. The OneDrive mobile app experience will be improved, as well as the synchronization from cloud to local machine.  We’ll see greater integration with Office products with Office 365 workloads and analytics will become available on the impact of your own work as a user in this platform.
  • Reinventing the Intranet – Perhaps the largest question we’ve all had on the future of SharePoint is what happened to the NextGen portals? Now we have our answer, “Intranet in your pocket.” The emphasis on the new SharePoint intranet experience is to make it even more consumable almost like an ‘intranet-in-a-box’ product.  It will be mobile ready, provide a new SharePoint home page for discovering sites and content, and it will come with a simple site provisioning process to improve the ease of site creation.  We’ll even see the Sites App Launcher tile get renamed to SharePoint.
  • Open Collaboration – Office 365 Groups are taking over the team sites space and we’ll finally see the integration of Office 365 Groups from Outlook get their very own SharePoint site. Groups (formerly known as team sites) will get a UI overhaul, but none of the sophisticated features of document libraries and lists will go away.  We also learned about Power Apps and Microsoft Flow as two new products to enable power users to create custom apps and simple workflows. There will be much more to discuss on this topic in the weeks to come and we can already speculate some of the implications of this announcement on the SharePoint products ecosystem.
  • Security, Privacy and Compliance – Microsoft continues to build its argument as a the best in class for security, privacy, and compliance not only as a cloud hosted application, but also for on-premises integration. Microsoft is making huge investments in the cloud, providing an end to end focus on manageability.  Enhancements in Data Loss Prevention and encryption using Customer Lock Box are a few of the features getting rolled out.

Despite the coming changes to a more integrated, slightly better looking SharePoint, the platform’s identity as a ubiquitous swiss-army knife for corporate productivity has not changed.  While the new SharePoint will enable power users and non-developers to produce better looking, mobile productivity solutions, Microsoft has left behind developer kits and mechanisms to continue to allow customization and heavy tailoring that previously allowed many organizations to take their SharePoint environments from meeting 60 percent of the requirements to something closer to 90 percent.

With a strong commitment to on-premises SharePoint Server releases in the future, the on-premises customer base can look forward to a feature pack in 2017, building upon the 2016 release and including the goodies mentioned in this presentation.

What is the future of SharePoint? We’ve all been asking ourselves this question for almost two years now.  We got a lot of our questions answered, and it looks like SharePoint as a brand is here to stay, whether it looks like any of its predecessors is the new question.

Are you wondering what it means for you? We will be posting and talking about the implications for your current SharePoint strategy in the coming months and beyond!

ASP.Net Interview Question and Answers for Mid Level

Posted on Updated on

 1. What are the asp.net page life cycle, name cycle?

Answer:

  1. PreInit()
  2. Init()
  3. InitComplete()
  4. PreLoad()
  5. Load()
  6. LoadComplete
  7. PreRender()
  8. Render()
  9. Unload()

2. What are the different Types of ASP.Net Validation Controls?

Answer:

RequireFieldValidator: validates for requiring filed or user input

RangeValidator: it validates the range of input filed like (0-9), (A-Z), (100-2000)

CompareValidator: it is used to compare the input control value with certain fixed value or another control value.

RegularExpressionValidator: it is used to express the input value as in required format or expression i.e. for formatting of phone number (e.g. 402-345-2344), date time format etc.

CustomValidator: it is used to customize the validation logic as needs of application logic.

      Validation Summary: displays all error message of validation controls on the page.

3. What are the various ways to send content from one page to another page?

Answer:

Server.Transfer()

Response.Redirect()

WebClient.DowloadFile()

4. What is difference between Server.Transfer() and Response.Redirect() and which is best?

Answer:

In case of Response.Redirect(), a new request is generated from client-side for the redirected page. It’s a kind of additional round trip. As the new request is generated from a client, so the new URL is visible to the user in a browser after redirection.

While in case of Server.Transfer(), a request is transferred from one page to another without making a round trip from the client. For the end user, URL remains the same in a browser even after transferring to another page.

Reference

5. Why Html Helper prefer than Asp Control?

Answer: The reason for preferring Html helper is lightweight though these are like ASP Controls.

6. What is the difference between Custom Control and User Control?

Answer:

Custom control is compiled code e.g: DLL. These are complex to create than User Controls and can easily be added in the toolbox. These can be used in multiple projects with drag and drop approach.

The user controls i.e. (ascx) are like design pages i.e. (aspx). These are comparatively easy to create than custom control and are tightly coupled with respect to code and UserInterface. These can be used in multiple projects with copy and paste method.

7. What is Global.aspx file and purpose of it?

Answer:

Global.asax is Asp.net Application File. It is located under App_Start Folder.

Main Purpose of it is to place the Application Level code such as Application start, Application End, Session Start, Session End and Application Error handle.

Main Events fired in Global.asax file is

 Application_Init:  fires for application initialization for the very first time.

Application_Start: fires when the application starts.

 Session_Start: fires when the user session starts.

Application_Error: fire when there occurs the error in application.

Session_End: fire when the user session ends.

Application_End: fire at the time of application end or timeout

8. What are the Types of Authentication available in ASP.net?

Answer:

Windows Authentication:

Form Authentication:

Passport Authentication:

9. What are Session State Modes in Asp.net?

Answer:

In-Proc:

State Server:

SQLServer:

Custom

Off

10. What are session state management processes in Asp.net?

    Answer:

In-Proc: Store the session in Web server Memory.

Out Proc: store the session in different external server either in State Server or SQL Server.

11. What is Difference between Session.Abandon() and Session.Clear()?

 Answer:

Session.Abandon(): Session.Abandon() destroy the running session with the firing of Session_End event from the Global.asax file. It releases the Session State Object and its items to free resources. 

Seesion.Clear(): It only clears the session data and set the value to null without killing the session. A resource becomes reserved with a null value.

12. What are the different Types of Catching inAsp.net?

Answer:

There are 3 types of catching.

OutPut Catching

Data Catching

Fragment Catching

13. Can we have the web application running without web.config file?

Answer: YES

14. Can we have multiple webconfig files in Asp.net Application?

Answer: Yes

15. Is it possible to create the web application with Asp.net web forms and MVC?

Answer: YES

We can create the hybrid application of Web forms and MVC by using following assembly references.

System.Web.MVC

System.Web.Razor

System.ComponentModel.DataAnnotations

16. Write a sample code to send email from Asp.net Application.

Answer:

MailMessage mailMsg=new MailMessage();

mailMsg.From=”sender@gmail.com”;

mailMsg.To=”receiver@gmail.com”;

mailMsg.Subject=”Email sending test”;

mailMsg.Body=”Email testing.”;

SmtpMail.SmtpServer=”Localhost”;

Smtp.Send(mailMsg);

17. What is the good practice for implementation of validation in Asp.net?

Answer:

Client Side validation is the best way to validate data in Asp.net application. Its Benefits are.

-Low network traffic.

-Save Server Resources.

18. What are the differences between WebConfig and Machine Config file?

Answer:

WebConfig File: It is specific to the web application. There can have multiple web config file into an application.

MachineConfig File: It is Specific to machine or server. There can be only one MachineConfig File into an application.

SQL Server Interview Question for Mid Level

Posted on Updated on

1.Write the script to create Table.

Answer:

CREATE TABLE Test
(
ID int,
LastName varchar(255),
FirstName varchar(255),

Address varchar(100),

);

2. What is Primary Key Constraint?

Answer:

The PRIMARY KEY constraint uniquely identifies each record in a database table. It must contain unique values and must not contain null values. Most of the tables should have a Primary key but there exists only one Primary Key for one table.

  1. What is Foreign Key Constraint?

Answer:

A FOREIGN KEY in one table points to a PRIMARY KEY in another table. There can exist multiple Foreign Key and Foreign Key may have null values. The FOREIGN KEY constraint prevents invalid data from being inserted into the foreign key column because it has to be one of the values contained in the table it points to.

Ref: https://msdn.microsoft.com/en-us/library/ms179610.aspx

 Ref

  1. What is Unique Constraint?

Answer:

The UNIQUE constraint uniquely identifies each record in a database table. Unique Constraint and Primary Key both provides the uniqueness of data in database table. There can be multiple Unique Key in Table but only One Primary Key. Primary Key itself has automatically defined Unique Constraint on it.

  1. How Union and Union All works in SQL server?

Answer:

Union gives the record only once if it occurs several times but Union All gives the record as several time that occurs in the table.

 

e.g.        Table 1

 ID Student Name
1 Ram
2 Shyam
3 Hari

Table 2

ID Student Name
1 Ram
2 Shyam
3 Hari
1 Ram
3 Shyam

Union Result

ID Student Name
1 Ram
2 Shyam
3 Hari

Union All Result

ID Student Name
1 Ram
2 Shyam
3 Hari
1 Ram
3 Shyam

 

  1. What are SQL Join?

Answer:

Inner Join: If we need Common records from both the tables we use Inner Join.

Outer Join: when we need a common and uncommon record from both the table outer join is used. The outer join is of two types on the basis of the unmatching record of which table is needed.

 

Left Outer Join: This gives all the record of the Left table and common record of the right table. Right Outer Join: This gives all the record of the Right table and common record of the left table.

Full Join: It gives all the record of both tables.

 7. Suppose you have the script of one database for one client and you need to create the same database for another client for same project deployment. How you ensure there is the exactly same database, there is no mismatch of the table, table name, columns and constraints in both the Database?

Answer:

By checking the Number of Tables, Number of Columns, Number of Constraints, Table Name etc we can ensure that there is no mismatch of database creation if there is anything missed we can find out what is missing with the help of it.

Query for Number of Table Count

select COUNT(* ) from INFORMATION_SCHEMA.TABLES

Query for Number of Column count

select COUNT(* ) from INFORMATION_SCHEMA.COLUMNS

Query for Number of Constraint Count

select COUNT(* ) from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

e.g.

If there is one table creation missing then running following below query in both database and comparing each other, we can find out which table is missing. This will give the name list of table in the database.

select TABLE_NAME from INFORMATION_SCHEMA.TABLES

 

  1. How many types of Function exists in SQL server explain with example?

Answer:

There are two types of SQL Function

  1. SQL Aggregate Functions

It returns a single value, calculated from values in a column.

Some of the Aggregate SQL Function are

AVG() – Returns the average value

COUNT() – Returns the number of rows

FIRST() – Returns the first value

LAST() – Returns the last value

MAX() – Returns the largest value

MIN() – Returns the smallest value

SUM() – Returns the sum

  1. SQL Scalar functions

SQL Scalar functions return a single value, based on the input value.

Some of the SQL Scalar Functions are

UCASE() – Converts a field to upper case

LCASE() – Converts a field to lower case

MID() – Extract characters from a text field

LEN() – Returns the length of a text field

ROUND() – Rounds a numeric field to the number of decimals specified

NOW() – Returns the current system date and time

FORMAT() – Formats how a field is to be displayed

 

 

  1. What is Difference Between Store Procedure and Function?

Answer:

– A Stored Procedure can return zero, single or multiple values. But, a function must return a single value.

– A Stored Procedure can have both input and output parameters whereas Functions can have only input parameters.

– Functions allow only a SELECT command whereas a Stored Procedure allows SELECT and other DML commands (INSERT, UPDATE and DELETE).

– A Stored Procedure can call a function, but a function can’t call a Stored Procedure.

– A Stored Procedure can use the try-catch block to handle exceptions. But try-catch is not allowed in functions.

– SQL transactions can be used in Stored Procedures but not in Functions.

  1. What is SQL Aliases?

Answer:

Aliases are used to give database Table Name or Table Column Name as Temporary Name. It is used to make column Name more readable.

SELECT ColumnName AS AliasName
FROM TableName;