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> }