public Vendedor GetOneOrDefaultById(long id)
{
try
{
var idInteger = (int)id;
using (var db = FarmaciaContext.Vendedor())
{
var sql = @"SELECT Nombre FROM vendedores WHERE ID_Vendedor = @id";
return(db.Database.SqlQuery <Vendedor>(sql,
new OleDbParameter("id", idInteger))
.FirstOrDefault());
}
}
catch (Exception ex) when(ex.Message.Contains(FarmaciaContext.MessageUnderlyngProviderFailed))
{
return(GetOneOrDefaultById(id));
}
}
