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());
}
}