简单的Web应用程序的替代SQL Server [英] Alternative to SQL Server for a simple web app

问题描述

我有一个使用SQL Server，Entity Framework，C＃和WCF编写的简单应用程序。当我想与朋友共享此应用程序时，我意识到他们没有在他们的计算机上使用SQL Server。我可以使用SQL Server Express版，因为我的应用程序是个人使用且非商业用途。

I have a simple app written using SQL Server, Entity Framework, C# and WCF. When I wanted to share this app with my friends, I realised they didn't use SQL Server on their machine. I could go for SQL Server Express edition, as the usage of my app is personal and non-commercial.

我发现MySQL是SQL Server的流行替代品。

I found MySQL as a popular alternative to SQL Server.

1）迁移到MySQL时是否需要更新实体？

1) Would I be required to update my entities when moving to MySQL?

2）我是否应该预期由于实体层的更改而导致BL层中的代码发生更改？ （我想知道是否为SQL Server构建了实体）

2) Should I anticipate code changes in my BL layer due to change in entities layer? (I am wondering whether entities was built for SQL Server)

是否存在类似于MS Access且比MySQL轻巧的数据库？

Are there any databases similar to MS Access that is lightweight compared to MySQL?

是否有任何不需要安装但可以像MS Access一样复制的数据库？

Are there any databases that need not be installed but can be copied around like MS Access?

感谢您的回应！

推荐答案

我不确定您的BLL看起来如何，我也没有使用实体框架的经验，但是我多次体验到linq-to-sql的效果要好得多

Im not sure how your BLL looks like and i have no experience with entity framework, but ive experienced multiple times that linq-to-sql works much better with sql-server as with any other database.

因此，除非您有充分的理由不使用sql express，否则我建议坚持使用sql express。

So unless you have a good reason not to use sql express, i'd advice to stick to sql express.

毕竟，在部署时应始终安装一些东西（除非您使用xml作为存储，这在linq-to-xml中是很可能的）

After all, you should always install something when deploying (unless you use xml as storage, which is quite well possible with linq-to-xml).

这篇关于简单的Web应用程序的替代SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！