在没有SQL Server可用的ISP上使用SQL Server MDF文件 [英] Using SQL Server MDF files on ISP without SQL Server available

问题描述

问候，



我有折扣ISP的投资组合网站。我刚用一个漂亮的MVC应用程序替换了我的大多数Web窗体应用程序。 ISP免费提供Access和MySQL（4.x），所以你可以做一些Db的东西，但使用任何MVC或ASP.Net默认安全是一件麻烦事。 SQL Server每月50美元，但他们真的打算为业务用户。我不知道有多少未来的雇主曾经看过这个网站，但我怀疑它很多，所以我不可能看到付费。



我很奇怪。如果您发布了网站，将SQL Server所需的引用设置为Copy Local = True，您认为可以读取MDF数据文件吗？您需要什么参考？ System.Data ......？



真的，这有点过头了，但是如果我的网站上有一点SQL Server功能的话会很棒。



感谢任何答案，迈克...就此而言，感谢多年来的许多答案。

Greetings,

I have a portfolio website at a discount ISP. I just replaced most of my Web Forms App with a nice MVC app. The ISP provides Access and MySQL(4.x) for free, so you can do some Db stuff, but working with anything MVC or ASP.Net default security is a hassle. It is $50 a month for SQL Server, but they really intend that for a business user. I don''t know how many prospective employers have ever looked at this site, but I doubt it is many, so I cannot possibly see paying for that.

I was wondering. If you published the website, setting the references you need for SQL Server as Copy Local=True, do you think you could read the MDF data file? What references would you need? System.Data ... ?

Really, this is a bit over my head, but it would be great if I had a little SQL Server capability on my web site.

Thanks for any answers, Mike ... For that matter, thanks for the many answers over the years.

推荐答案

每月50个SQL Server，但他们真的打算为业务用户。我不知道有多少未来的雇主曾经看过这个网站，但我怀疑它很多，所以我不可能看到付费。



我很奇怪。如果您发布了网站，将SQL Server所需的引用设置为Copy Local = True，您认为可以读取MDF数据文件吗？您需要什么参考？ System.Data ......？



真的，这有点过头了，但是如果我的网站上有一点SQL Server功能的话会很棒。



感谢任何答案，迈克...就此而言，感谢多年来的许多答案。

50 a month for SQL Server, but they really intend that for a business user. I don''t know how many prospective employers have ever looked at this site, but I doubt it is many, so I cannot possibly see paying for that.

I was wondering. If you published the website, setting the references you need for SQL Server as Copy Local=True, do you think you could read the MDF data file? What references would you need? System.Data ... ?

Really, this is a bit over my head, but it would be great if I had a little SQL Server capability on my web site.

Thanks for any answers, Mike ... For that matter, thanks for the many answers over the years.

你无法使用C＃读取MDF文件。您可以查询文件的元数据，但不能查询数据库数据。

You cannot read MDF file using C#. You can query meta data of the file but not the database data.

这篇关于在没有SQL Server可用的ISP上使用SQL Server MDF文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！