[转]OData – the best way to REST–实例讲解ASP.NET WebAPI OData (V4) Service & Client

Install-Package Microsoft.AspNet.OData

未能加载文件或程序集“System.Web.Http, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35”或它的某一个依赖项。找到的程序集清单定义与程序集引用不匹配。 (异常来自 HRESULT:0x80131040)

<system.web>
<compilation debug="true" targetFramework="4.5"/>
<httpRuntime targetFramework="4.5"/>
</system.web>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Http" publicKeyToken="31BF3856AD364E35" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Net.Http.Formatting" publicKeyToken="31BF3856AD364E35" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>

{
"@odata.context":"http://localhost:20491/$metadata#People","value":[
{
"ID":"001","Name":"Angel","Description":null
},{
"ID":"002","Name":"Clyde","Description":"Contrary to popular belief, Lorem Ipsum is not simply random text."
},{
"ID":"003","Name":"Elaine","Description":"It has roots in a piece of classical Latin literature from 45 BC, making Lorems over 2000 years old."
}
]
}

错误 1 正在运行转换: System.ArgumentException: The value "" is not a valid MetadataDocumentUri because is it not a valid absolute Uri. The MetadataDocumentUri must be set to an absolute Uri referencing the $metadata endpoint of an OData service.
在 Microsoft.VisualStudio.TextTemplating0CFD4DFE54AE767D51F4D19A4964CA0B33E6E87CF53FFF790646D6E3F14916C4544A62E4C781ABB55BC19EE5225FDBA7E28D9767E56040F8F9A9EF5278D6B7CA.GeneratedTextTransformation.set_MetadataDocumentUri(String value) 位置 c:\Users\dth\Documents\Visual Studio 2013\Projects\ODataWebApplication\Demo.ConsoleClient\ODataClient1.ttinclude:行号 125
在 Microsoft.VisualStudio.TextTemplating0CFD4DFE54AE767D51F4D19A4964CA0B33E6E87CF53FFF790646D6E3F14916C4544A62E4C781ABB55BC19EE5225FDBA7E28D9767E56040F8F9A9EF5278D6B7CA.GeneratedTextTransformation.ApplyParametersFromConfigurationClass() 位置 c:\Users\dth\Documents\Visual Studio 2013\Projects\ODataWebApplication\Demo.ConsoleClient\ODataClient1.ttinclude:行号 313
在 Microsoft.VisualStudio.TextTemplating0CFD4DFE54AE767D51F4D19A4964CA0B33E6E87CF53FFF790646D6E3F14916C4544A62E4C781ABB55BC19EE5225FDBA7E28D9767E56040F8F9A9EF5278D6B7CA.GeneratedTextTransformation.TransformText() 位置 c:\Users\dth\Documents\Visual Studio 2013\Projects\ODataWebApplication\Demo.ConsoleClient\ODataClient1.ttinclude:行号 58 c:\Users\dth\Documents\Visual Studio 2013\Projects\ODataWebApplication\Demo.ConsoleClient\ODataClient1.ttinclude 125 1 Demo.ConsoleClient

// The URI of the metadata document. The value must be set to a valid service document URI or a local file path
// eg : "http://services.odata.org/V4/OData/OData.svc/", "File:///C:/Odata.edmx", or @"C:\Odata.edmx"
// ### Notice ### If the OData service requires authentication for accessing the metadata document, the value of
// MetadataDocumentUri has to be set to a local file path, or the client code generation process will fail.
public const string MetadataDocumentUri = "http://localhost:20491/";

class Program
{
static void Main(string[] args)
{
// TODO: Replace with your local URI.
string serviceUri = "http://localhost:20491/";
var container = new DefaultContainer(new Uri(serviceUri)); foreach (var p in container.People)
{
Console.WriteLine("{0} {1} {2}", p.ID, p.Name, p.Description);
} Console.Read();
}
}

Install-Package Microsoft.OData.Client

<?xml version="1.0" encoding="utf-8"?>
<packages>
<package id="Microsoft.OData.Client" version="6.11.0" targetFramework="net40" />
<package id="Microsoft.OData.Core" version="6.11.0" targetFramework="net40" />
<package id="Microsoft.OData.Edm" version="6.11.0" targetFramework="net40" />
<package id="Microsoft.Spatial" version="6.11.0" targetFramework="net40" />
</packages>

using Microsoft.OData.Client;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;namespace PWMIS.OData.Client
{
/// <summary>
/// OData V4 Version ASP.NET WebAPI OData RestFull Client Context
/// <remarks>v1.0 2015.4.1 http://www.pwmis.com/sqlmap </remarks>
/// </summary>
public class ODataV4ContextBase : DataServiceContext
{
/// <summary>
/// V4 OData Init
/// </summary>
/// <param name="serviceRoot">V4 OData ASP.NET WebAPI url base</param>
public ODataV4ContextBase(string serviceRoot)
: base(new System.Uri( serviceRoot), ODataProtocolVersion.V4)
{
if (!serviceRoot.EndsWith("/"))
serviceRoot = serviceRoot + "/";
GeneratedEdmModel gem = new GeneratedEdmModel(serviceRoot);
this.Format.LoadServiceModel = gem.GetEdmModel;
this.Format.UseJson();
} public IQueryable<T> CreateNewQuery<T>(string name) where T : class
{
return base.CreateQuery<T>(name);
} class GeneratedEdmModel
{
private string ServiceRootUrl;
public GeneratedEdmModel(string serviceRootUrl)
{
this.ServiceRootUrl = serviceRootUrl;
} public Microsoft.OData.Edm.IEdmModel GetEdmModel()
{
string metadataUrl = ServiceRootUrl + "$metadata";
return LoadModelFromUrl(metadataUrl);
} private Microsoft.OData.Edm.IEdmModel LoadModelFromUrl(string metadataUrl)
{
System.Xml.XmlReader reader = CreateXmlReaderFromUrl(metadataUrl);
try
{
return Microsoft.OData.Edm.Csdl.EdmxReader.Parse(reader);
}
finally
{
((System.IDisposable)(reader)).Dispose();
}
} private static System.Xml.XmlReader CreateXmlReaderFromUrl(string inputUri)
{
return System.Xml.XmlReader.Create(inputUri);
}
}
}
}

class ODataContainer : PWMIS.OData.Client.ODataV4ContextBase
{
public ODataContainer(string serviceRoot):base(serviceRoot)
{ } public IQueryable<Person> People
{
get
{
return base.CreateNewQuery<Person>("People");
} }
}

private void button1_Click(object sender, EventArgs e)
{
string serviceUri = "http://localhost:20491/";
var container = new ODataContainer(serviceUri);
var query = container.People.Where(p => p.Description!=null);
this.dataGridView1.DataSource = query.ToList();
}