Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
If the WHERE clause of the generated SQL finds the record (even if the update doesn't make changes because the new value is equal to the existing one), SaveChanges() returns the number of rows found. I have run the following code:KevClark64 wrote:I'm still investigating this, but I think I may have found the issue. It may be that SaveChanges is returning 0 when the data to be saved is not different from the existing data. In other words, I'm grabbing a record, updating some values, and then calling SaveChanges. But the updated data may be the same data that already was in the record.
Code: Select all
static void Main(string[] args)
{
var monitor = new Devart.Data.PostgreSql.PgSqlMonitor() { IsActive = true };
int first = 0;
int second = 0;
using (var context = new PostgreModel.PostgreEntities())
{
var dept = context.Depts.Where(a => a.Deptno == 10).FirstOrDefault();
dept.Dname = "development";
first = context.SaveChanges();
}
using (var context2 = new PostgreModel.PostgreEntities())
{
var dept2 = context2.Depts.Where(a => a.Deptno == 10).FirstOrDefault();
dept2.Dname = "development";
second = context2.SaveChanges();
}
}