public async Task <ExecutionStatus <IReadOnlyList <CallForSpeech> > > Run(FilterCallForSpeechStyles filtrer) { using var connection = new SqliteConnection (_geekLemonContext.ConnectionString); IEnumerable <CallForSpeechTemp> r; var q = @$ "SELECT c.UniqueId ,c.Version, c.Id,c.Number,c.Status,c.PreliminaryDecision_DecisionBy, c.PreliminaryDecision_Date,c.FinalDecision_DecisionBy, c.FinalDecision_Date,c.Speaker_Name_First,c.Speaker_Name_Last, c.Speaker_Adress_Country,c.Speaker_Adress_ZipCode, c.Speaker_Adress_City, c.Speaker_Adress_Street,c.Speaker_Websites_Facebook,c.Speaker_Websites_Twitter, c.Speaker_Websites_Instagram,c.Speaker_Websites_LinkedIn,c.Speaker_Websites_TikTok, c.Speaker_Websites_Youtube,c.Speaker_Websites_FanPageOnFacebook,c.Speaker_Websites_GitHub, c.Speaker_Websites_Blog, c.Speaker_BIO, c.Speaker_Contact_Phone,c.Speaker_Contact_Email, c.Speech_Tags, c.Speech_ForWhichAudience,c.Speech_TechnologyOrBussinessStory,c.Registration_RegistrationDate, c.CategoryId,c.Score_Score, c.Score_RejectExplanation,c.Score_WarringExplanation, c.Speaker_Birthdate,c.Speech_Title,c.Speech_Description, k.Name AS {nameof(JudgeTemp.Category_Name)},
public Task <ExecutionStatus <IReadOnlyList <CallForSpeech> > > GetCollectionAsync(FilterCallForSpeechStyles filtrer) { return(_callForSpeechGetCollectionDoer.Run(filtrer)); }