Poradzie mi czemu wyświetla mi taki błąd:
Exception thrown: 'System.Data.Entity.Core.EntityCommandExecutionException' in EntityFramework.SqlServer.dll ("An error occurred while executing the command definition. See the inner exception for details.")
przy wywołaniu polecenia
var answercollection = dbcontext.Answers.Where(x => x.SomeQuestion.questionID == questo.questionID).Select(x => new { x.optionToVote }).ToList();
Model wygląda tak:
Klasa Answer
public class Answer : INotifyPropertyChanged
{
private int AnswerID;
public int answerID
{
get { return AnswerID; }
set
{
if (AnswerID != value)
{
AnswerID = value;
OnPropertyChange("answerID");
}
}
}
private eOptionToVote OptionToVote;
public eOptionToVote optionToVote
{
get { return OptionToVote; }
set
{
if (OptionToVote != value)
{
OptionToVote = value;
OnPropertyChange("optionToVote");
}
}
}
public virtual User SomeUser { get; set; }
public virtual Question SomeQuestion { get; set; }
public event PropertyChangedEventHandler PropertyChanged;
public void OnPropertyChange(string property)
{
if (PropertyChanged != null)
{
PropertyChanged(this, new PropertyChangedEventArgs(property));
}
}
}
Klasa Question
public class Question : INotifyPropertyChanged
{
private int QuestionID;
public int questionID
{
get { return QuestionID; }
set
{
if (QuestionID != value)
{
QuestionID = value;
OnPropertyChange("questionID");
}
}
}
private string Title;
public string title
{
get { return Title; }
set
{
Title = value;
OnPropertyChange("title");
}
}
public virtual ICollection<Answer> AnswerCollection { get; set; }
public event PropertyChangedEventHandler PropertyChanged;
public void OnPropertyChange(string propertyName)
{
if (PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
klasa user
public class User : INotifyPropertyChanged
{
private int UserID;
public int userID
{
get { return UserID; }
set
{
if (UserID != value)
{
UserID = value;
OnPropertyChange("userID");
}
}
}
private string Login;
public string login
{
get { return Login; }
set
{
if (Login != value)
{
Login = value;
OnPropertyChange("login");
}
}
}
private eOptionToVote OptionTypeLogin;
public eOptionToVote optionTypeLogin
{
get { return OptionTypeLogin; }
set
{
if (OptionTypeLogin != value)
{
OptionTypeLogin = value;
OnPropertyChange("optionTypeLogin");
}
}
}
public virtual ICollection<Answer> AnswerCollection { get; set; }
public event PropertyChangedEventHandler PropertyChanged;
public void OnPropertyChange(string property)
{
if (PropertyChanged != null)
{
PropertyChanged(this, new PropertyChangedEventArgs(property));
}
}
}