如何使用ASP.NET Web API OData在Oracle中使用Entity Framework 6.x Code

环境: Visual Studio 2013 + .Net Framework 4.5.2

1.新建项目

2.安装OData，ODP.NET

安装的包：

下面是部分代码：

using System;using System.Collections.Generic;using System.Linq;using System.Web;namespace WebAppOdataEF.Models{  public class AUDIT_TEMPLATE  {    /// <summary>    /// Gets or sets the identifier.    /// 自增ID    /// </summary>    /// <value>The identifier.</value>    public decimal ID { get; set; }    /// <summary>    /// Gets or sets the audit template no.    /// 审批模板编码    /// </summary>    /// <value>The audit template no.</value>    public string AUDITTEMPLATENO { get; set; }    /// <summary>    /// Gets or sets the name of the audit template.    /// 审批模板名称    /// </summary>    /// <value>The name of the audit template.</value>    public string AUDITTEMPLATENAME { get; set; }    /// <summary>    /// Gets or sets the bill type no.    /// 单据类型    /// </summary>    /// <value>The bill type no.</value>    public string BILLTYPENO { get; set; }    /// <summary>    /// Gets or sets the remark.    /// 备注    /// </summary>    /// <value>The remark.</value>    public string REMARK { get; set; }    /// <summary>    /// Gets or sets the template status.    /// 状态1有效 0无效    /// </summary>    /// <value>The template status.</value>    public decimal TEMPLATESTATUS { get; set; }    /// <summary>    /// Gets or sets the company no.    /// 公司编码    /// </summary>    /// <value>The company no.</value>    public string COMPANYNO { get; set; }    /// <summary>    /// Gets or sets the create time.    /// 创建时间    /// </summary>    /// <value>The create time.</value>    public DateTime CREATETIME { get; set; }    /// <summary>    /// Gets or sets the create user no.    /// 创建人    /// </summary>    /// <value>The create user no.</value>    public string CREATEUSERNO { get; set; }    /// <summary>    /// Gets or sets the update time.    /// 更新时间    /// </summary>    /// <value>The update time.</value>    public DateTime UPDATETIME { get; set; }    /// <summary>    /// Gets or sets the update user no.    /// 更新人    /// </summary>    /// <value>The update user no.</value>    public string UPDATEUSERNO { get; set; }  }}

using System;using System.Collections.Generic;using System.Linq;using System.Net;using System.Net.Http;using System.Web.Http;using System.Web.OData;using WebAppOdataEF.Models;namespace WebAppOdataEF.Controllers{  public class TemplatesController : ODataController  {    TemplatesContext db = new TemplatesContext();    private bool TestExists(int key)    {      return db.Templates.Any(p => p.ID == key);    }    protected override void Dispose(bool disposing)    {      db.Dispose();      base.Dispose(disposing);    }    [EnableQuery]    public IHttpActionResult Get()    {      return Ok(db.Templates);    }    [EnableQuery]    public SingleResult<AUDIT_TEMPLATE> Get([FromODataUri] int key)    {      IQueryable<AUDIT_TEMPLATE> result = db.Templates.Where(p => p.ID == key);      return SingleResult.Create(result);    }  }}

  (CONNECT_DATA =   (SERVER = DEDICATED)   (SERVICE_NAME = test)  ) );User ID=test;Password=test;Persist Security Info=True" providerName="Oracle.ManagedDataAccess.Client" /> </connectionStrings>  <system.web>  <compilation debug="true" targetFramework="4.5" />  <httpRuntime targetFramework="4.5" /> </system.web> <system.data>  <DbProviderFactories>   <remove invariant="Oracle.ManagedDataAccess.Client" />   <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver"     type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />  </DbProviderFactories></system.data> <system.webServer>  <handlers>   <remove name="ExtensionlessUrlHandler-Integrated-4.0" />   <remove name="OPTIONSVerbHandler" />   <remove name="TRACEVerbHandler" />   <add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />  </handlers> </system.webServer> <runtime>  <assemblyBinding 

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：如何使用ASP.NET Web API OData在Oracle中使用Entity Framework 6.x Code

关键词：ASP.NET