public List <Words> Translate(int id, List <Words> words, int?LastLanguageId = 1) { var sql = "GetTranslations"; DataTable OrginalWords = helpService.CreateTableValuedParameter(words); con = connectionFactory.CreateConnection(DBname); using (con) { con.Open(); var parameters = new { IdLanguage = id, Words = OrginalWords, LastLanguageId }; return(con.Query <Words>(sql, parameters, commandType: CommandType.StoredProcedure).ToList()); } }