This question is locked. New answers and comments are not allowed.
var query =
from contact
in
context.Contacts
group contact by contact.Name
into g
select
new
{ Name = g.Key, AvgAge = g.Average(e => e.Age) };
The following exception occurs:
System.InvalidCastException: Type cast exception: double required, found System.Int64 ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Double()
at System.Data.SqlClient.SqlDataReader.GetDouble(Int32 i)
at OpenAccessRuntime.Data.DoubleConverter.Read(DataHolder& data)
--- End of inner exception stack trace ---
at OpenAccessRuntime.Data.DoubleConverter.Read(DataHolder& data)
at OpenAccessRuntime.Relational.fetch.FopGetProjection.fetch(FetchResult fetchResult, StateContainer stateContainer)
at OpenAccessRuntime.Relational.fetch.FetchSpec.createRow(FetchResult fetchResult, StateContainer stateContainer)
Processing 1: [0] System.InvalidCastException: Type cast exception: double required, found System.Int64 ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Double()
at System.Data.SqlClient.SqlDataReader.GetDouble(Int32 i)
at OpenAccessRuntime.Data.DoubleConverter.Read(DataHolder& data)
--- End of inner exception stack trace ---
at OpenAccessRuntime.Data.DoubleConverter.Read(DataHolder& data)
at OpenAccessRuntime.Relational.fetch.FopGetProjection.fetch(FetchResult fetchResult, StateContainer stateContainer)
at OpenAccessRuntime.Relational.fetch.FetchSpec.createRow(FetchResult fetchResult, StateContainer stateContainer)