[WebMatrix] WebMatrix Beta3의 새로운 기능과 변경된 부분 소개 – 릴리즈 노트

안녕하세요. 코난 김대우 입니다. 이번에 발표된 WebMatrix Beta3가 발표 되었고, 간단히 새로운점소개해 드리려고 합니다.

Beta3를 받아서 이전 강좌들을 죽 검토하면서 느낀건, Beta1에서 Beta2처럼 많은 중요한 변경(Breaking Change)가 있기 보다는 대단히 안정성과 마이너한 부분에서 변경이 이루어진 것 같습니다. MVC3와 호환성도 어느정도 근접했다는 느낌이 드네요. 간략히, Beta3의 릴리즈노트 내용을 제목 정도만 휘리릭~ 리뷰하도록 하겠습니다. 도움 되시길 바랍니다.


Web Matrix and ASP.NET Web Pages (Razor) Beta 3 Release Readme

WebMatrix Beta 3
설치 관련 이슈

Issue: WebMatrix Beta3 설치를 위해서는 반드시 .NET Framework 4.0 버전이 필요합니다.

The .NET Framework version 4 is required for WebMatrix Beta. In certain cases, the WebMatrix Beta installer will let you try to install on a platform that is not part of the supported configuration set. In particular, Windows Vista without the SP1 update will let you begin the installation of WebMatrix Beta, but the .NET Framework 4 component will fail and block your installation.

Install on a supported platform, which includes:

· Windows 7

· Windows Server 2008

· Windows Server 2008 R2

· Windows Vista SP1 or later

· Windows XP SP3

· Windows Server 2003 SP2

Issue: 만약, PC Visual Studio 2008 설치되어 있을 경우, Visual Studio 2008 SP1 있어야만 WebMatrix Beta3 설치됩니다.

Install Microsoft Visual Studio 2008 SP1 from the Microsoft Download Center.

Issue: SQL CE 4.0 몇몇 어셈블리가 GAC 설치되지 않는 이슈

The managed assemblies for SQL Server Compact 4.0 are not placed in the global assembly cache (GAC) when you install SQL Server Compact 4.0 on a 64-bit computer and the computer has only the .NET Framework 3.5 SP1 Client Profile installed. The managed assemblies that are not installed in the GAC are:

· System.Data.SqlServerCe.dll (ADO.NET provider)

· System.Data.SqlServerCe.Entity.dll (ADO.NET Entity Framework )

Uninstall SQL Server Compact 4.0. Download and install the full version of .NET Framework 3.5 SP1 from the following location:
Microsoft .NET Framework 3.5 Service pack 1 (Full Package)
Then reinstall SQL Server Compact 4.0.

Issue: 명령프롬프트에서 SQL CE 제거되지 않는 이슈

Uninstallation of SQL Server Compact using command-line options does not work in this release.

Use Programs and Features in the Windows Control Panel to uninstall Microsoft SQL Server Compact 4.0.

ASP.NET Web Pages 관련 사항 - 새로운 기능 / 변경점 / 이슈

This section of the document describes new features, changes, and known issues with the Beta 3 release of ASP.NET Web Pages with Razor syntax.

New Features in Beta 3 for ASP.NET Web Pages with Razor Syntax

New: "Html.Raw" metohd renders unencoded markup

The new Html.Raw method lets you render HTML markup as markup instead of rendering encoded output. (By default, ASP.NET Razor encodes strings before rendering them.) The syntax is:


The following example shows how to use Html.Raw:

@* Inserts literal markup into the page as specified in the value string. *@

@Html.Raw("<div>Hello <em>world</em>!</div>")

ASP.NET Web Pages w/ Razor Beta3 변경점

Change: "HrefAttribute" 메서드 제거

The HrefAttribute method of the WebPage class has been removed. This helper was used to encode unsafe characters in URLs. It is no longer required because ASP.NET Razor automatically encodes strings. (Use the new Html.Raw method to render unencoded strings.)

Change: "@Helper" helper 선언 문구 변경

In the Beta 3 release, ASP.NET changes how it parses helpers that are created using the @helper syntax. In essence, the @helper syntax is now parsed as a code block instead of as a block of markup that can include code. Therefore, code inside the helper does not need to be enclosed in @{ } blocks. Conversely, markup inside the helper has to be explicitly included in HTML elements or in ASP.NET Razor <text></text> tags.

For example, the following @helper syntax works in the Beta 3 release:

@helper ThumbnailLink(string imagePath, int width, int height) {


string newFileName = "";

WebImage thumbnail = new WebImage(imagePath);

if(thumbnail != null){

thumbnail.Resize(width, height, true, true);

newFileName = @"~\thumb_" + Path.GetFileName(thumbnail.FileName);




<a href="@Href(imagePath"><img src="@Href(newFileName" /></a>


In the Beta 3 release, this helper must be changed to look like the following example:

@helper ThumbnailLink(string imagePath, int width, int height) {

string newFileName = "";

WebImage thumbnail = new WebImage(imagePath);

if(thumbnail != null){

thumbnail.Resize(width, height, true, true);

newFileName = @"~\thumb_" + Path.GetFileName(thumbnail.FileName);



<a href="@Href(imagePath"><img src="@Href(newFileName" /></a>


Notice that the @{ } characters around the initial code in the helper is no longer used. This is because the contents of the helpers are treated as a code block by default. The helper renders markup, which starts with the opening <a> tag. If the helper must render plain text or tags that do not include a closing tag (for example, <meta> tags), the content to be rendered must be in <text></text> tags.

Change: "WebPageContext.HttpContext" 제거됨

The WebPageContext.HttpContext property has been removed. Use HttpContext.Current instead. (The WebPageContext.HttpContext property simply wrapped this.)

Change: "Facebook" helper 새로운 패키지로 변경됨

The Facebook helper has been moved to the Facebook.Helper library, which includes the Facebook helper and additional functionality. You must install this library as a separate package, as described in "Installing Helpers with Package Manager" in the tutorial Getting Started with ASP.NET Pages.

Change: Membership, Role Security type 새로운 어셈블리로 변경됨

The following types were moved to the WebMatrix.WebData assembly:

· ExtendedMembershipProvider

· SimpleMembershipProvider

· SimpleRoleProvider

· WebSecurity

Change: "TagBuilder" 클래스가 System.Web.WebPages.dll 어셈블리로 변경됨

The TagBuilder class has been moved to the System.Web.WebPages.dll assembly. Previously, this was in an assembly that was part of ASP.NET MVC. This change means that you do not have to install ASP.NET MVC in order to use the TagBuilder class.

However, the class is still in the System.Web.Mvc namespace. In order to use the TagBuilder class (for example, in a custom ASP.NET Razor helper), you must reference the namespace (for example, by adding @using System.Web.Mvc to your code).

Change: Request validation 구문 변경됨 ; "Validation" 클래스 제거됨

In the Beta 3 release, to disable validation for an individual field or set of fields, you can call the Validation.Exclude method, passing in the name or names of the fields to exclude from validation. A new syntax is available in the Beta 3 release for bypassing validation. The Validation method used in Beta 3 has been removed.

Note If you do not disable request validation, if users try to upload HTML markup (for example, by using a rich text editor on a page), the website will report an error like A potentially dangerous Request.Form value was detected from the client and the user input is not accepted. If you disable request validation, you must manually check user input to make sure that it does not contain potentially dangerous markup or script using something like the Microsoft Anti-Cross Site Scripting Library V4.0.

To disable automatic request validation, call the Request.Unvalidated method, passing it the name of the field or other post object that you want to bypass request validation for. You can use this method to bypass validation for any items in the Form, QueryString, Cookies, and ServerVariables collections. The following examples show how to use the Unvalidated method:

Request["userInput"]; // Validated

Request.Unvalidated("userInput"); // Validation bypassed

Request.Unvalidated().Form["userInput"]; // Validation bypassed

Request.QueryString["userPreference"]; // Validated

Request.Unvalidated().QueryString["userPreference"]; // Validation bypassed

ASP.NET Web Pages with Razor Syntax 알려진 이슈들

Issue: 사용자 정의 membership 테이블 사용시 비정상 동작 발생

To initialize the membership provider for an ASP.NET Razor website, you call the WebSecurity.InitializeDatabaseConnection method. (In WebMatrix, the Starter Site template includes a call to this method in the _AppStart.cshtml file.) If the autoCreateTables parameter of this method is set to true (by default, it is set to true in the Starter Site template), and if an unrecognized table name is passed to the method (the second parameter), the method does not throw an error. Instead, it automatically creates the table.

This can be a problem if you intend to use a custom user table for membership but pass the wrong table name to the WebSecurity.InitializeDatabaseConnection method. Because the method does not by default raise an error if the table you specify does not exist, and because it instead creates a new table, the application can appear to be working. However, application code that relies on your custom user table (and on fields in it) can eventually fail with unexpected errors.

Make sure that the name passed in the InitializeDatabaseConnection method matches the user profile table in the membership database, or make sure that the autoCreateTables parameter is set to false.

Issue: "Failed to generate a user instance of SQL Server" 오류

If a WebMatrix Web application uses SQL Server Express and is running IIS 7.5 on Windows 7 or Windows Server 2008 R2, you might see an error that indicates that SQL Server cannot retrieve the user's local application path at run time.

Make sure that the Windows account that the application runs under (typically NETWORK SERVICE) has read/write permissions for root folders of the application and for subfolders such as App_Data. More detailed information is available in the KnowledgeBase article Problems with SQL Server Express user instancing and ASP.net Web Application Projects.

Issue: Visual Studio에서 사용자 정의 어셈블리(DLL) 네임스페이스가 자동으로 import 되지 않는 이슈

If you use custom assemblies in a project in Visual Studio, the namespaces declared in those assemblies are not automatically imported at design time. As a result, references to custom types might not be recognized at design time and are marked as not recognized in Visual Studio (using a "squiggle"). This problem occurs only at design time in Visual Studio; the application itself runs properly.

Include a using statement (imports in Visual Basic) that references the entities that are not recognized at design time.

Issue: Visual Studio 인텔리센스는 ASP.NET MVC 3프로젝트 템플릿에서만 동작

Installing ASP.NET Web Pages does not also install tools for Visual Studio such as IntelliSense and project templates for ASP.NET Web Pages applications.

To use IntelliSense and project templates for ASP.NET Web Pages applications in Visual Studio, install ASP.NET MVC 3 RC either through the Web Platform Installer or the stand-alone installer.

Issue: "<helper> class cannot be found" 오류

After you upgrade to Beta 3, you might see an error that a helper class (for example, the Facebook class) cannot not be found. Starting in Beta 2 and continuing in Beta 3, helpers have been moved to packages that you must explicitly install. Existing sites are not upgraded to include these packages; this includes sites in the \My Documents\IISExpress or \My Documents\My Web Sites folders. In particular, you will see this error if you use the default site in My Sites (WebSite1), which includes a reference to the Twitter helper.

Comment out calls to any helpers in the site, run the _Admin page, and install the package or packages that include the helpers that you want to use. (For details, see New: Package support added for ASP.NET Web Pages later in this document.) After you've installed the package, you can uncomment the lines that reference helpers.

Issue: 특정 호스팅 사이트에서 Bin 폴더의 Razor 어셈블리 배포에 문제가 있을 수 있다.

If you deploy an ASP.NET Web Pages website to a hosting site, and if you deploy the ASP.NET Razor Beta 3 assemblies to the site's Bin folder, you might experience errors, including the following:

Could not load type 'Microsoft.Web.Infrastructure.DynamicModuleHelper.DynamicModuleUtility' from assembly 'Microsoft.Web.Infrastructure, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.

This can happen if the hosting provider has installed the ASP.NET Web Pages Beta 1 assemblies into the server's global application cache (GAC). Assemblies in the GAC get precedence over assemblies installed locally in the Bin folder.

Workaround Contact your hosting provider to confirm that the errors you are seeing are due to a conflict between the provider's versions of the assemblies and yours. If so, request that the hosting provider update the assemblies in the server's GAC.

Issue: 프록시 서버를 통해 피드나 외부 데이터를 읽을 경우

If the server running the site is behind a proxy server, you might need to configure proxy information in the Web.config file in order to be able to read information that comes from outside your site. For example, if you use the ReCaptcha helper, the helper communicates with the reCAPTCHA service, but might be blocked by your proxy server. Similarly, feeds that are used in ASP.NET Web Pages, such as the feed used by the package manager, might require proxy configuration.

If you experience problems in working with an external service or working with the package feed, put the following elements into your application's root Web.config file:



<proxy autoDetect="False"

proxyaddress="[proxy URL]"/>



For more information about configuring a proxy server, see <proxy> Element (Network Settings) on the MSDN Web site.

Issue: "Microsoft.Web.Infrastructure.dll cannot be loaded" 오류

If you previously installed the Beta 1 version of ASP.NET Web Pages with Razor syntax and then install the Beta 3 version, all appropriate assemblies are installed in the GAC except Microsoft.Web.Infrastructure.dll. As a consequence, when you run ASP.NET Razor pages, you see an error that indicates that Microsoft.Web.Infrastructure.dll could not be loaded.

This issue does not occur if you loaded the Beta 3 release on a clean computer.

In Control Panel, uninstall ASP.NET Web Pages. Then reinstall the Beta 3 release.

Issue: .NET Framework 4.0 제거 재설치 ASP.NET Web Pages with Razor Syntax 사용 불가 이슈

If you uninstall the .NET Framework version 4 and then reinstall it, ASP.NET Web Pages with Razor syntax is disabled. Pages with the .cshtml extension do not run correctly. ASP.NET Web Pages registers an assembly in the machine root Web.config file, and removing the .NET Framework removes that file. Reinstalling the .NET Framework installs a new version of the configuration file, but does not add the reference for the ASP.NET Web Pages assembly.

Workaround After reinstalling the .NET Framework, reinstall ASP.NET Web Pages with Razor syntax. This adds the following element to the Web.config file in the machine root, which is typically in the following location:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config (32-bit)
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config (64-bit)



<add assembly="Microsoft.WebPages.Configuration, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />

<-- Additional assemblies here. -->



Issue: Bin 폴더에 이미 배포한 ASP.NET 어셈블리들이 오류를 유발

During deployment, copies of the ASP.NET Web Pages assemblies (for example, Microsoft.WebPages.dll) to the Bin folder of the website on the server. (This might have happened automatically during deployment or because the developer explicitly copied the assemblies.) However, when the Beta 3 release is installed, errors occurs, such as errors that certain types cannot be found. This occurs because a number of ASP.NET Web Pages types were moved into different namespaces for the Beta 3 release.

Clear the Bin folder of the deployed application, copy the new assemblies to the folder (or redeploy the application), and then restart the application.

Issue: IIS7이나 IIS7.5에서 URL cshtml이나 vbhtml 확장자를 찾지 못하는 이슈 발생

On IIS 7 or IIS 7.5, requests with a URL like the following are not able to find pages that have the .cshtml or .vbhtml extension:
The issue arises because URL rewriting is not enabled by default for IIS 7 or IIS 7.5. The likeliest scenario is that you do not see the problem when testing locally using IIS Express, but you experience it when you deploy your website to a hosting website.


· If you have control over the server computer, on the server computer install the update that is described in A update is available that enables certain IIS 7.0 or IIS 7.5 handlers to handle requests whose URLs do not end with a period.

· If you do not have control over the server computer (for example, you are deploying to a hosting website), add the following to the website's Web.config file:

<modules runAllManagedModulesForAllRequests="true"/>

Issue: ASP.NET MVC ASP.NET Web Pages 하나의 어플리케이션에서 사용하는 이슈

If you were using ASP.NET Web Pages in a Web Application project or ASP.NET MVC application, you might see an error that WebPageHttpApplication cannot be found.

If you get this error, change the base class from which the application derives. In the Global.asax file, change the following line:

public class MvcApplication : WebPageHttpApplication { ... }

To this:

public class MvcApplication : HttpApplication { ... }

This in effect reverses a change that was introduced for the Beta 1 release of ASP.NET Web Pages with Razor syntax.

Issue: SQL CE 설치되어 있지 않은 시스템에 SQL CE 사용하는 어플리케이션을 배포

Applications that include SQL Server Compact databases can run on a computer where SQL Server Compact is not installed. Microsoft WebMatrix Beta 3 automatically copies these binaries for you and performs the appropriate Web.config file transforms.

If you need to copy these files and make the Web.config file changes manually, do the following :

1. Copy the database engine assemblies to the Bin folder (and subfolders) of the application on the target computer:

o Copy C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Desktop\System.Data.SqlServerCe.dll to \Bin

o Copy C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private\x86\* to \Bin\x86

o Copy C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private\amd64\* to \Bin\amd64

2. In the root folder of the website, create or open a Web.config file. (In WebMatrix Beta 3, this file type is available if you click All in the Choose a File Type dialog box.)

3. Add the following element as a child of the <configuration> element (not inside the <system.web> element):

<remove invariant="System.Data.SqlServerCe.4.0"></remove>
<add name="Microsoft SQL Server Compact Data Provider"
Description=".NET Framework Data Provider for Microsoft SQL Server Compact"
type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>

Issue: Database WebGrid helper들이 Visual Basic Medium Trust 에서 동작 안하는 이슈

If you are using Visual Basic (creating .vbhtml files), the Database and WebGrid helpers will not work if the application is set to use Medium Trust.

Temporarily set the application to use Full Trust.

SQL Server Compact 관련

Issue: "Encrypt" 속성이 동작 안함

SQL Server Compact 4.0 does not recognize the Encrypt property of the SqlCeConnection class. You should not use this property to encrypt database files. The Encrypt property was deprecated in SQL Server Compact 3.5 release and was retained only for backward compatibility.

Use the Encryption Mode property of the SqlCeConnection class to encrypt SQL Server Compact 4.0 database files. The following example shows how to create an encrypted SQL Server Compact 4.0 database using the Encryption Mode property:


SqlCeEngine engine = new SqlCeEngine("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;");

Visual Basic

Dim engine As SqlCeEngine = New SqlCeEngine("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;")

To change the encryption mode of an existing SQL Server Compact 4.0 database, do the following:


SqlCeEngine engine = new SqlCeEngine("Data Source=Northwind.sdf;Password=<enterStrongPasswordHere>;");
engine.Compact("Data Source=Northwind.sdf;encryption mode=ppc2003 compatibility;Password=<enterStrongPasswordHere>;");

Visual Basic

Dim engine As SqlCeEngine = New SqlCeEngine("Data Source=Northwind.sdf;Password=<enterStrongPasswordHere>;")
engine.Compact("Data Source=Northwind.sdf;encryption mode=ppc2003 compatibility;Password=<enterStrongPasswordHere>;")

To encrypt an unencrypted SQL Server Compact 4.0 database, do the following:


SqlCeEngine engine = new SqlCeEngine("Data Source=Northwind.sdf");
engine.Compact("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;");

Visual Basic

Dim engine As SqlCeEngine = New SqlCeEngine("Data Source=Northwind.sdf;")
engine.Compact("Data Source=Northwind.sdf;encryption mode=platform default;Password=<enterStrongPasswordHere>;")

Issue: Microsoft Visual C++ 2008 런타임 라이브러리 요구

The native DLLs of SQL Server Compact 4.0 need the Microsoft Visual C++ 2008 Runtime Libraries (x86, IA64, and x64), Service Pack 1.

Install the .NET Framework 3.5 SP1. This also installs the Visual C++ 2008 Runtime Libraries SP1. You can download the libraries from the following location:
Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package ATL Security Update

Note that installing the .NET Framework 2.0, 3.0, or 4 does not install the Visual C++ 2008 Runtime Libraries SP1.

Issue: If SQL Server Compact is installed prior to installing .NET Framework on the computer, its provider invariant name is not registered in the .NET Framework machine.config file

SQL Server Compact can be installed on a machine that does not have .NET Framework installed because SQL Server Compact does require the .NET framework. If neither .NET Framework version 3.5 nor 4 is installed before you install SQL Server Compact, the SQL Server Compact Setup does not register its provider invariant name in the machine.config file. Any application that relies on the SQL Server Compact entry in the machine.config file will fail. The invariant name registration entry in machine.config looks like the following example:

<remove invariant="System.Data.SqlServerCe.4.0"></remove>

name="Microsoft SQL Server Compact Data Provider"


Description=".NET Framework Data Provider for Microsoft SQL Server Compact"
type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe,

Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>

Uninstall SQL Server Compact 4.0 CTP1. Download and install the full versions of the .NET Framework from the following location:

Microsoft .NET Framework 3.5 Service pack 1 (Full Package)
Microsoft .NET Framework 4.0 Release (Full Package)

Then reinstall SQL Server Compact 4.0 CTP1.

Applications 설치

Issue: 내문서” 폴더가 네트워크 공유로 redirect 되어 있으면 설치가 오래 걸린다.

None. The application might take a while to install, but will install correctly.

Applications 배포

Issue: 배포시 "Destination URL" http나 https로 설정되어 있지 않을 경우 동작하지 않을 수 있다.

In the Publishing Settings dialog box, if the destination URL does not begin with http:// or https://, the site might not work after deployment.

Make sure that before you publish a site, the destination URL in the Publish Settings dialog box starts with http:// or https://.

Issue: MySQL 데이터베이스 배포시"Failed to publish the database. This can happen if the remote database cannot run the script." 오류 발생

The error can occur for a number of reasons. One reason you can see this error is if the database script contains a single quotation character (') and the destination MySQL database's default character set is not to UTF-8.

Set the default character set for the remote MySQL database to UTF-8.

Other Issues

Issue: Search/Filter does not work in Reports for Group By: Issue Type

When you run a report for a site, if you enter text in the Filter by URL box and click Search, nothing happens. This is because this control is not functional while the Group By state of the report is set to Issue Type, which is the default.

In the Group By tab of ribbon, click URL to group the entries by their source URL. The text box and button to filter the entries are functional while in this state.

Issue: IIS Express WCF 어플리케이션을 실행시 오류 발생

Browsing to a WCF application results in an error like the following one:

Could not load file or assembly 'Microsoft.Web.Administration, Version=, Culture=neutral,PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

This occurs because IIS Express Beta release doesn’t support WCF by default.

Use any one of the following workarounds (workaround #2 requires Microsoft Windows Vista or higher):

1. Copy the Microsoft.Web.dll and Microsoft.Web.Administration.dll assemblies from the WebMatrix installation location to the bin directory of the WCF application. By default, WebMatrix is installed in the Microsoft WebMatrix subfolder under the system's Program Files folder.

2. On Microsoft Windows Vista or higher, create a symlink to the assemblies in the bin directory using the following commands. (This approach has the advantage that it does not create a copy of the assemblies.)

3. mklink Microsoft.Web.Administration.dll "c:\Program Files (x86)\Microsoft WebMatrix\Microsoft.Web.Administration.dll"

mklink Microsoft.Web.dll "c:\Program Files (x86)\Microsoft WebMatrix\Microsoft.Web.dll"

4. Install the two assemblies in the GAC. From an elevated prompt, run the following commands:

5. gacutil /i "c:\Program Files (x86)\Microsoft WebMatrix\Microsoft.Web.Administration.dll"

gacutil /i "c:\Program Files (x86)\Microsoft WebMatrix\Microsoft.Web.dll"

Issue: 특정 권한 상승 작업이 요구될 경우 WebMatrix Beta3가 작업을 수행 못할 수 있다.

WebMatrix Beta 3 is unable to perform certain tasks that require elevation, such as installing additional components in the following situations:

· On Windows Vista or Windows 7, you are logged in with an account that does not have administrative privileges and User Account Control (UAC) is disabled.

· You are using Microsoft Windows XP or Microsoft Windows Server 2003.

Most tasks in WebMatrix Beta 3 do not require administrative permission. For those that do, you can perform the operation as an administrator, or follow these steps:

· On Windows Vista or Windows 7, enable UAC.

· On Windows XP, add the user to the Administrators security group.

Issue: "Site from Web Gallery" 비활성화 되어 있다.

The Site from Web Gallery option is disabled if the Web Platform Installer 3.0 is not installed.

Install the Microsoft Web Platform Installer 3.0.

Issue: Windows 서버 2003에서 IIS Express 관리자권한 사용자로 시작되지 못한다.

On Windows Server 2003, when you launch a page or start IIS Express, IIS Express does not start. For Web pages, an error is displayed that indicates that the application has been started by a non-administrative user.

Start WebMatrix Beta 3 as an administrative user. For more details, see the following KnowledgeBase article:
An application that is started by a non-administrative user cannot listen to the HTTP traffic of the computer on which the application is running in Windows Vista, Windows Server 2003, or Windows XP.

Issue: 구글 크롬이 Run 옵션에 나타나지 않는다.

Google Chrome is not displayed in the list of browsers under Run on the Home tab.

Some versions of Google Chrome do not register themselves correctly with the Default Programs feature in Windows. As a workaround, start Google Chrome, click the Customize and control Google Chrome menu, click Options, and then click Make Google Chrome my default browser.

Issue: "Foreign Key" 대화상자가 PK 입력을 허용하지 않는다.

The Foreign Key dialog box does not allow you to enter the primary key name from the primary key table.

This is intentional. You do not need to enter the name of the primary key from the primary key table.

Issue: The "Relationships" 버튼이 비활성화 되어 있다.

The Relationships button under the Table tab in the Databases workspace is disabled for SQL Server Compact databases.

None. SQL Server Compact does not support relationships between tables.

Issue: 파라미터화된 SQL 쿼리가 예외를 발생시킨다. Parameterized SQL queries throw exceptions

In SQL Server Compact 4.0, if you do not specify a data type such as SqlDbType or DbType for parameters in parameterized queries, an exception is thrown when the query runs.

Explicitly set the data type for parameters such as SqlDbType or DbType. This is critical in the case of BLOB data types (image and ntext). Use code like the following:


SqlCeEngine engine = new SqlCeEngine(connString);
SqlCeConnection conn = new SqlCeConnection(connString);
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "CREATE TABLE BlobTable(name nvarchar(128), blob ntext);";
cmd.CommandText = "INSERT INTO BlobTable(name, blob) VALUES (@name, @blob);";
SqlCeParameter paramName = cmd.Parameters.Add("name", SqlDbType.NVarChar, 128);
SqlCeParameter paramBlob = cmd.Parameters.Add("blob", SqlDbType.NText);
paramName.Value = "Name1";
paramBlob.Value = "Name1".PadLeft(4001);

Visual Basic

Dim engine As SqlCeEngine = New SqlCeEngine(connString)
Dim conn As SqlCeConnection = New SqlCeConnection(connString)
Dim cmd As SqlCeCommand = conn.CreateCommand()
cmd.CommandText = "CREATE TABLE BlobTable(name nvarchar(128), blob ntext);"
cmd.CommandText = "INSERT INTO BlobTable(name, blob) VALUES (@name, @blob);"
Dim paramName As SqlCeParameter
Dim paramBlob As SqlCeParameterparamName = cmd.Parameters.Add("name", SqlDbType.NVarChar, 128)
paramName.Value = "Name1"
paramBlob = cmd.Parameters.Add("blob", SqlDbType.NText)
paramBlob.Value = "Name1".PadLeft(4001)

For More Information

For more information about WebMatrix Beta 3, see the following websites:

Comments (0)

Skip to main content