在ASP.NET网站中使用SQL Server Compact Edition

发布时间：2020-12-16 06:37:52 所属栏目：asp.Net 来源：网络整理

导读：我对数据库几乎一无所知,但需要在我的ASP.NET小网站上存储和呈现用户输入(最多几千条记录).我应该考虑SQL Server Compact Edition吗？在Microsoft文档中,我发现： SQL Server Compact 3.5 is not currently optimized to serve as a database for Web sites.

我对数据库几乎一无所知,但需要在我的ASP.NET小网站上存储和呈现用户输入(最多几千条记录).我应该考虑SQL Server Compact Edition吗？在Microsoft文档中,我发现：

SQL Server Compact 3.5 is not currently optimized to serve as a database for Web sites. By default,connections from ASP.NET-connected applications are blocked in SQL Server Compact 3.5. SQL Server Compact 3.5 is optimized for use as an embedded database within applications. Using SQL Server Compact 3.5 as a database for Web sites requires support for multiple users and concurrent data changes. This can cause performance problems. Therefore,these scenarios are not supported. Other editions of SQL Server,including SQL Server 2005 Express Edition and later versions,are optimized to serve as a database for Web sites.

但后来我记得阅读一些用户评论,说明4.0版本的SQL Server CE在ASP.NET场景中最终正常工作.有人愿意分享他的经历吗？我想首先尝试CE,因为SQL服务器需要我的托管额外费用.

解决方法

从 download site for SQL Server Compact 4.0：

Microsoft SQL Server Compact 4.0 is a free,embedded database that software developers can use for building ASP.NET websites and Windows desktop applications.

和：

SQL Server Compact 4.0 enables new scenarios and includes a host of new features,including the following:

SQL Server Compact 4.0 is the default database for Microsoft WebMatrix,which is a stack of web technologies for easily building and deploying websites on the Windows platform.

(强调我的)

总而言之 – 它已针对Web场景进行了专门增强.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!