ASP.NET 4.5入门：数据库与开发实践

需积分: 10 199 浏览量更新于2024-07-22 收藏 7.75MB PDF 举报

《asp.net 4.5数据库入门经典(第3版)》是一本全面指南，旨在帮助读者掌握在ASP.NET 4.5环境中利用ado.net、entity framework和C#进行数据库驱动网站开发的技能。本书详细介绍了如何高效地设计和实现专业级的解决方案，涵盖了从基础数据源连接到高级应用架构管理的各个环节。第1章“ASP.NET 4.5数据源”引领读者了解和设置项目的基础，介绍如何使用ASP.NET框架提供的内置数据源来创建和管理数据驱动的网页。第2章“关系型数据库的未来”探讨了现代数据库技术趋势，包括新特性与对传统关系数据库的扩展使用，为适应未来数据库环境做好准备。第三章和第四章分别关注“非关系型数据库”，介绍了NoSQL数据库的兴起及其在Web开发中的角色，以及如何通过ADO.NET访问这些新型数据存储方式。第五章和第六章深入解析ADO.NET Entity Data Model（ADO.NET实体数据模型），这是.NET框架中处理数据访问的重要组件，展示了如何使用LINQ (Language-Integrated Query) 来简化数据查询和操作。第七章聚焦于Entity Framework，讲解如何设计和实现高效的数据访问应用程序，包括其核心概念和最佳实践。第八章进一步剖析Entity Framework的数据访问模式，帮助读者理解其在复杂数据结构和分布式系统中的应用策略。第九章介绍了Windows Communication Foundation (WCF) 数据服务，它是消费和提供RESTful API的一种方式，有助于数据的远程共享和交互。第十章“数据绑定在ASP.NET 4.5中”讲述了如何利用数据绑定功能将数据无缝集成到网页视图中，提高用户体验。第十一章和第十二章探讨了如何构建可扩展的、数据驱动的Web应用，包括动态数据和最佳开发实践，以确保应用程序的灵活性和性能。最后，第十三章关注应用程序生命周期管理，涵盖了部署、监控和维护数据驱动网站的全面策略。通过这本书，读者将不仅学会如何使用ASP.NET 4.5与数据库交互，还将收获关于开发高效、稳健的数据库驱动网站的宝贵经验。无论是初学者还是经验丰富的开发人员，都能从中找到适合自己的学习资源和技术提升路径。

CHAPTER 1 ■ ASP.NET 4.5 DATA SOURCES

catch (Exception)

{

//Log Exception

}

You will notice that the main thread is not blocked, and you can continue to see the results inside the while loop

that checks for the IAsyncResult IsCompleted property. A simple callback handler will look like the following:

private static void CallBack(IAsyncResult result)

{

try

{

var command = (SqlCommand)result.AsyncState;

command.EndExecuteNonQuery(result);

}

catch (Exception)

{

//Log Exception

}

For a simple asynchronous execution of the command, this is lot of code. You will find out how this is simplified

in .NET Framework 4.5.

Note ■ In order for the asynchronous operation to work, the attribute “Asynchronous Processing=true” needs to be

set on the connection string element of your configuration file.

Async Programming Model in .NET Framework 4.5

The asynchronous programming model just discussed has not been deprecated in .NET Framework 4.5. It

continues to be supported; however, the preferred approach is to use the new model leveraging a task-based parallel

programming pattern along with async and await modifiers. It is very important that you implement the modifiers

appropriately. The implementation can become synchronous unless one follows an async call by one or more await

modifiers. The async modifier indicates an asynchronous operation, and when the program execution encounters the

await modifier, it exits the current method. When the forked task finishes, execution resumes in the method.

Caution ■ Asynchronous operations are not supported if the attribute "Context Connection" is set to "true" in the

connection string.

The ADO.NET Async programming model in .NET Framework 4.5 exposes an equivalent asynchronous method

for every synchronous method exposed by the data providers. Continuing with the previous example, the SqlCommand

ExecuteNonQuery command has an equivalent asynchronous method named ExecuteNonQueryAsync. It accepts a

CancellationToken as a parameter allowing the operation to be aborted before the command timeout elapses.

Now let’s take a look at how the programming model significantly reduces the lines of code you have to write for

the same operation.

CHAPTER 1 ■ ASP.NET 4.5 DATA SOURCES

Notice the ContinueWith method. It allows you to delegate anonymously a task-based operation. You can use

the ContinueWith option to execute a chain of commands. In addition, the async programming model also provides

support for transactions:

transaction = await Task.Run<SqlTransaction>(

() => connection.BeginTransaction("Transaction")

);

......

await Task.Run(() => transaction.Commit());

Developing Your First Example

Let’s now put our theories into practice and explore the steps to create data-driven web sites using ASP.NET 4.5.

For the purpose of this exercise, you will use Visual Studio 2012 Ultimate Edition with .NET Framework 4.5. Also,

you will be running the example inside of a Windows 8 System running Internet Explorer 10. You can, however, run

this sample from your machine running Windows 7 or above using Visual Studio 2012 Express Edition. The application

should run fine on IE 8 or above.

The editions of Visual Studio 2012 includes a lightweight web server in IIS Express, so if you don’t have access to

a full-fledged version of IIS, you can use the Express edition to test your deployment.

Caution ■ Some of the features discussed in this exercise are specific to Visual Studio 2012. The exercise may not

work correctly if you are trying to run it with .NET Framework 4.5 in Visual Studio 2010.

Various editions of Visual Studio 2012 and .NET Framework 4.5 can be downloaded from

http://www.microsoft.com/visualstudio/eng#downloads.

In addition, for data access you will use the SQL Server Express LocalDB database that ships with Visual Studio 2012.

However, the example should work fine with SQL Server 2008 R2, SQL Server 2012, and SQL Azure.

Try It Out: First Data-Driven Page in ASP.NET 4.5

In this example, you will create a simple data-driven page in ASP.NET 4.5 using the Entity Model concepts I discussed

thus far. For this example, you will use the SQL Server Express LocalDB Gadgets database, which stores information

about different gadgets and the available quantity. In the end, the result will display the name of the gadget, followed

by its type and quantity.

Let’s first create the database. Follow these steps:

1. If you are using Windows 8 to create this example, then Visual Studio can be launched

from the Start screen. Go to the Start screen and click the Visual Studio tile, as shown

in Figure 1-5. This will take you to Desktop and launch the integrated development

environment (IDE).

剩余266页未读，继续阅读

KevinWu2019

粉丝: 1
资源: 158

ASP.NET 4.5入门：数据库与开发实践

Beginning ASP.NET 4.5 Databases

asp.net实现ctrl+f的全文检索功能

exception during geoip databases update java.net.SocketTimeoutException: connect timed out

databases.net自定义tr样式不生效

class Databases: db = Databases()

exception during geoip databases update java.net.SocketTimeoutException: connect timed out 是什么原因导致的？

php图书管理系统的参考文献

CONFIG GET databases返回

mysql> SHOW DATABASES ->

python安装databases

最新资源