Require source files to exactly match the original version(0)

VS 2010 :Unable to start debugging on the web server. The Web Server Could Not Find the Requested Resource

 

 

 

After installling VS 2010 Express, I was very excited to work on it. As soon as I installed the application on the machine, I was so happy and planned to do many RAD (Rapid Application Development).

But that excitement was for only short time. I started getting the problem of Unable to start debugging on the web server. The Web Server Could Not Find the Requested Resource.

I tried plenty of options, I was so discouraged and I went back to my old VS 2008, but this too was behaving the same. I was cursing myself why I tried to install VS 2010.

But from some bodies guidelines I followed it and found the solution

i. Install URLSCAN 2.5 from Microsoft. UrlScan version 2.5 is a security tool that restricts the types of HTTP requests that Internet Information Services (IIS) will process ii. Locate and change the urlscan.ini. (Should be in %windir%\system32\inetsrv\urlscan). iii. Open the urlscan.ini file in notepad. iV. Inside the urlscan.ini file locate ALLOWEXTENSIONS Section add .aspx

V. Locate in the same file ALLOWVERBS Section add DEBUG

VI. Don't forget to restart IIS. VII. Start> Run > iisreset - Enter.

CRUD in Entity Framework

This Article is an attempt to show CRUD in Entity Framework as simple as possible.

We are using MSSQL Server, VS 2010 and Asp.net 4.0

To download VS 2010, and ASP.NET 4.0 you can do it from this.

What exactly we are doing.

1. Creating a simple 2 column Table in new Database.

2. Creating new Website Application on VS 2010 in c#.

3. Adding Ad0.net Entity Data Model , naming it as Model.edmx.

4. Assigning it to our Database.

5. In a simple page implementing the CRUD no validations are used.

1. Database.

Run this script in your MSSQL .

GO
/****** Object:  Database [EFrameWorkCRUD]    Script Date: 04/21/2010 16:28:52 ******/
CREATE DATABASE [EFrameWorkCRUD] ON  PRIMARY
( NAME = N'EFrameWorkCRUD', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\EFrameWorkCRUD.mdf' , SIZE = 1216KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'EFrameWorkCRUD_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\EFrameWorkCRUD_log.LDF' , SIZE = 504KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'EFrameWorkCRUD', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [EFrameWorkCRUD].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [EFrameWorkCRUD] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET ANSI_NULLS OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET ANSI_PADDING OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET ARITHABORT OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [EFrameWorkCRUD] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [EFrameWorkCRUD] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [EFrameWorkCRUD] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET  ENABLE_BROKER
GO
ALTER DATABASE [EFrameWorkCRUD] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [EFrameWorkCRUD] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [EFrameWorkCRUD] SET  READ_WRITE
GO
ALTER DATABASE [EFrameWorkCRUD] SET RECOVERY FULL
GO
ALTER DATABASE [EFrameWorkCRUD] SET  MULTI_USER
GO
ALTER DATABASE [EFrameWorkCRUD] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [EFrameWorkCRUD] SET DB_CHAINING OFF 

2. Create a New Website "EFrameWork"

Add Entity Data model to it.

3. Assign our Database into this .edmx. It will look like this.

4. In a .aspx page add this.

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
  <title></title>
</head>
<body>
  <form id="form1" runat="server">
  <div>
  Load Select(Reat) <asp:DropDownList runat=server ID="ddl" ></asp:DropDownList><br />
  (Create) <asp:TextBox runat=server ID=txtcreate ></asp:TextBox>
      <asp:Button runat=server ID=btncreate  Text=create onclick="btncreate_Click"/><br />
  (Edit) <asp:TextBox runat=server ID=TextBox1 ></asp:TextBox>
      <asp:Button runat=server ID=Button1  Text=edit onclick="Button1_Click"/><br />
  <asp:Button runat=server ID=Button2  Text=delete onclick="Button2_Click"/>
  </div>
  </form>
</body>
</html>

5. In .aspx.cs add this.

protected void Page_Load(object sender, EventArgs e)
   {      
       lineModel.lineEntities db = new lineModel.lineEntities();
       var a = from u in db.AnswerMasters  select new { u.Id, u.Count };
       this.ddl.DataSource = a.ToList();
       this.ddl.DataTextField= "Id";
       this.ddl.DataTextField = "Id";
       this.ddl.DataBind();
   }
   protected void btncreate_Click(object sender, EventArgs e)
   {
       lineModel.lineEntities db = new lineModel.lineEntities();
       lineModel.AnswerMaster A = new lineModel.AnswerMaster();
       A.Count= Convert.ToInt32(this.txtcreate.Text);
       db.AnswerMasters.AddObject(A);
       db.SaveChanges();
   }
  
   protected void Button1_Click(object sender, EventArgs e)
   {
       lineModel.lineEntities db = new lineModel.lineEntities();       
       lineModel.AnswerMaster A = (from u in db.AnswerMasters where u.Id==1 select u).SingleOrDefault();
       if (A != null)
           A.Count = Convert.ToInt32(this.TextBox1.Text);
       db.SaveChanges();
   }
   protected void Button2_Click(object sender, EventArgs e)
   {
       lineModel.lineEntities db = new lineModel.lineEntities();
       lineModel.AnswerMaster A = (from u in db.AnswerMasters where u.Id == 2 select u).SingleOrDefault();
       db.AnswerMasters.DeleteObject(A);
       db.SaveChanges();
   }

Hope this gives basic idea about how to do CRUD in EF.

Please leave messages if you have any problem to understand.