且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用实体框架中选择SQL函数

更新时间:2023-11-20 21:47:22

还有一堆的,你可以的LINQ querys在 SqlFunctions 使用SQL Server功能的类 System.Data.Objects.SqlClient 命名空间。

There is a bunch of Sql Server functions that you can use in Linq querys in SqlFunctions class in System.Data.Objects.SqlClient namespace.

看做工一样,在为Postgre您的LINQ提供程序库,如果你不能找到添加一个计算列与 asbinary(the_geom)的值和地图该列在EF。

Look for sth like that in your Linq Provider library for Postgre, and if you can't find add a computed column with the value of asbinary(the_geom) and map that column in EF.

您甚至可以写事物一样,如果你看一下反编译code,

You may even could write sth like that if you look at the decompiled code,

public static class SqlFunctions
{
    // Methods
    [EdmFunction("SqlServer", "STR")]
    public static string StringConvert(double? number)
    {
    }
}