通过ADO.NET数据服务客户端库访问SQL数据服务

时间:2021-08-02 20:02:09

Is this possible? Basically I would like to use SQL Data Services REST interface and let the ADO.NET Data Service Client library handle communication details and generate the entities that I can use. I looked at the samples in February release of Azure services kit but the samples in there are using HttpWebRequest and HttpWebResponse to consume SQL Data Services RESTfully. I was hoping to use ADO.NET Data Service Client library to abstract low-level details away.

这可能吗?基本上我想使用SQL Data Services REST接口,让ADO.NET数据服务客户端库处理通信细节并生成我可以使用的实体。我查看了2月发布的Azure服务工具包中的示例,但其中的示例使用HttpWebRequest和HttpWebResponse来RESTful地使用SQL数据服务。我希望使用ADO.NET数据服务客户端库来抽象低级细节。

2 个解决方案

#1


Yes you can! Or at least, they're working on it...

是的你可以!或者至少,他们正在努力......

They've changed the direction of SDS since Februari (they will now be offering an actual relational database), butI haven't had the chance to dive into this subject since, so I'm not 100% certain which parts already work.

自从Februari(他们现在将提供一个实际的关系数据库)以来,他们已经改变了SDS的方向,但我没有机会深入研究这个问题,所以我不是100%确定哪些部分已经有效。

See this SDS team blog post for information.

有关信息,请参阅此SDS团队博客文章。

#2


You can do this easily now (as of MIX10). When you create a database in SQL Azure, there is now an option to expose an OData endpoint (REST-based endpoint) over that data. Once you do this, you can point the WCF Data Services (formerly known as the ADO.NET Data Services) client, VIA Add Service Reference in Visual Studio, at the endpoint and get the generated data services client for that SQL Azure endpoint.

您现在可以轻松完成此操作(从MIX10开始)。在SQL Azure中创建数据库时,现在可以选择在该数据上公开OData端点(基于REST的端点)。完成此操作后,您可以在端点指向WCF数据服务(以前称为ADO.NET数据服务)客户端,Visual Studio中的VIA添加服务引用,并获取该SQL Azure端点的生成数据服务客户端。

#1


Yes you can! Or at least, they're working on it...

是的你可以!或者至少,他们正在努力......

They've changed the direction of SDS since Februari (they will now be offering an actual relational database), butI haven't had the chance to dive into this subject since, so I'm not 100% certain which parts already work.

自从Februari(他们现在将提供一个实际的关系数据库)以来,他们已经改变了SDS的方向,但我没有机会深入研究这个问题,所以我不是100%确定哪些部分已经有效。

See this SDS team blog post for information.

有关信息,请参阅此SDS团队博客文章。

#2


You can do this easily now (as of MIX10). When you create a database in SQL Azure, there is now an option to expose an OData endpoint (REST-based endpoint) over that data. Once you do this, you can point the WCF Data Services (formerly known as the ADO.NET Data Services) client, VIA Add Service Reference in Visual Studio, at the endpoint and get the generated data services client for that SQL Azure endpoint.

您现在可以轻松完成此操作(从MIX10开始)。在SQL Azure中创建数据库时,现在可以选择在该数据上公开OData端点(基于REST的端点)。完成此操作后,您可以在端点指向WCF数据服务(以前称为ADO.NET数据服务)客户端,Visual Studio中的VIA添加服务引用,并获取该SQL Azure端点的生成数据服务客户端。