public void CharIndex2()
{
decimal?checkSum = SqlFunctions.ChecksumAggregate(from o in jambore.SalesOrderHeader select o.SalesOrderID);
Console.WriteLine(checkSum);
Console.ReadKey();
}
public void SqlFunctions_aggregate_function_translated_properly_to_sql_function()
{
using (var context = new ArubaContext())
{
var query = context.AllTypes.Select(a => SqlFunctions.ChecksumAggregate(context.AllTypes.Select(i => i.c1_int)));
Assert.Contains("CHECKSUM_AGG", query.ToString().ToUpperInvariant());
}
}
public static void D()
{
//<snippet4>
using (AdventureWorksEntities AWEntities = new AdventureWorksEntities())
{
// SqlFunctions.ChecksumAggregate is executed in the database.
decimal?checkSum = SqlFunctions.ChecksumAggregate(
from o in AWEntities.SalesOrderHeaders
select o.SalesOrderID);
Console.WriteLine(checkSum);
}
//</snippet4>
}
