无法在VS2017中为sql serverCE创建数据源 [英] Can't create a datasource for sql serverCE in VS2017

问题描述

服务器资源管理器窗口显示sql server CE链接及其表，但是当我尝试从表创建数据源时，我收到一条错误消息：

    "从数据库中检索信息时发生错误

     此选择器不支持指定的类型"

我可以毫无问题地设置SQL Server数据源，所以这里发生了什么？

谢谢

罗宾

解决方案

RFBaker，

欢迎来到MSDN论坛。

可以您是否提供有关您的问题的详细步骤，以帮助我们重新发现并找到解决方案？

并且，根据错误消息，用户Pavel遇到了与您相同的错误，并且用户ErikEJ为Pavel的问题提供了
a相应的答案。

"Pavel：DDEX提供程序是简单的，如名称所示，仅存在以支持EF向导.https：//github.com/ErikEJ/SqlCeToolbox/issues/39
- 但另外，使用带有sql ce的DatSet是一个坏主意，因为所有数据都在内存中缓冲两次。使用linq来代替sql或EF。工具箱包含快速生成linq到sql或ef代码的工具。"

参考：

http://erikej.blogspot.sg/2015/03/sql-server-compact-sqlite-toolbox-42.html

注意：此响应包含对第三方万维网站点的引用。为方便起见，Microsoft提供此信息
。

Microsoft不控制这些网站，也没有测试在这些网站上找到的任何软件或信息;

因此，Microsoft不能对任何软件的质量，安全性或适用性做出任何陈述。
或在那里找到的信息。

问候，

Judyzh

The server explorer window shows the sql server CE link and its tables but when I try to create a datasource from a table I get an error message :

    "An error occurred while retrieiving information from the database

     The specified type is not supported by this selector"

I can set up SQL Server data sources with no problem so what is happening here?

Thanks

Robin

解决方案

Hi RFBaker,

Welcome to the MSDN forum.

Could you please provide the detail steps about your issue that help us to repro it and find the solutions?

And, according to the error message, the user Pavel encountered the same error as yours, and the user ErikEJ provides a corresponding answer for Pavel’s issue.

"Pavel: the DDEX provider is Simple as stated in the name, and only exists to support the EF Wizards. https://github.com/ErikEJ/SqlCeToolbox/issues/39 - but in addition, using DatSet with sql ce is a bad idea, as all data is buffered twice in memory. Use linq to sql or EF instead. The toolbox includes tools to quickly generate both linq to sql or ef code."

Reference: http://erikej.blogspot.sg/2015/03/sql-server-compact-sqlite-toolbox-42.html

Note: This response contains a reference to a third-party World Wide Web site. Microsoft is providing this information as a convenience to you.

Microsoft does not control these sites and has not tested any software or information found on these sites;

Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there.

There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

Regards,

Judyzh

这篇关于无法在VS2017中为sql serverCE创建数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！