冰点博客

代码如下:

var pd = from a in p.PROJECTINFO
                  join b in p.PROJECTINFO on a.HigherID equals b.ID into c
                 from d in c.DefaultIfEmpty() 
                 orderby a.ID
                 select new {a.ID,a.ProjectName ,a.ProjectTypeID,a.Constructionunit,gk=d.ProjectName };

aps.net:linq to oracle11整了很久,终于解决.

参考:http://blogs.msdn.com/b/jkowalski/archive/2008/10/24/using-ef-oracle-sample-provider-with-edm-designer.aspx

1. 下载 解压 EFOracleSampleProvider.zip  http://code.msdn.com/EFOracleProvider 把整个解决方案重新生成一遍.

2.运行 CMD,命令行输入:

notepad %WINDIR%\Microsoft.NET\Framework\v2.0.50727\config\machine.config

阅读全文…