我应该使用哪个数据库 [英] which database i should use

问题描述

你好，
目前，我正在Visual Studio 2008中为学校管理系统开发Windows应用程序，但由于客户端不希望使用sql server 2005或lator，我很困惑应该为该应用程序使用哪个数据库，然后给我带代码的最佳建议.
我可以使用本地数据库.sdf吗?
如果是，那么请给我发送代码，以更新和删除.sdf文件....
谢谢...

hello,
right now i m developing a windows application for school management system in visual studio 2008, but i am confused which database i should use for this application because client don''t want to sql server 2005 or lator, then give me best suggestion with code.
can i use local database .sdf ?
if yes then kindly send me code for insert update and delete for .sdf file....
thank you...

推荐答案

是-如果您不希望多用户访问数据库，则可以使用SDF文件.它们作为SqlCE对象进行访问，因此只需将您的SqlConnection和SqlCommand对象替换为SqlCEConnection和SqlCECommand对象即可.

如果您不执行命令链接或存储过程(SqlCE均不支持)，则该命令应全部正常工作.

Yes - provided you do not want multiuser access to the database then you can use SDF files. They are accessed as SqlCE objects, so just replace your SqlConnection and SqlCommand objects with SqlCEConnection and SqlCECommand objects instead.

Provided you do not do command chaining, or stored procedures (neither of which SqlCE supports) it should all work.

对于学校项目，我认为您应该使用免费的数据库，例如MySQL.
如果您可以访问办公室，则可以考虑使用MS Access.

For a school project, I think you should use a free database like MySQL.
If you have access to office then you can think about MS Access.

这篇关于我应该使用哪个数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！