Entity Framework Core: How Can I update Entity no duplicate values?

Question

I have a student table that has three fields.

1.ID. is PK 2.No. just like student number 3.Name. student Name

when I use EF core to update student name. I need to make sure that the student name and student number are not duplicated

This is my method

// get same name student
var currenItem = await _context.TLibInfo.FirstOrDefaultAsync(v => v.name== item.name);
// check if current is null I can update
if (currenItem == null)
{
// get student by number
 var existItem = await _context.TLibInfo.FirstOrDefaultAsync(v => v.no == item.no);
 if (existItem != null)
 {
    // then update
 }
}

Is there a better way for me not to query twice?

For example It is not insert. It is update. just like I have 2 record.

id:1 name: davis number: A

id: 2 name: Jack number: B

I want to update id:2 record.

I want to make sure that when I update name, the name is not davis

Svyatoslav Danyliv · Accepted Answer · 2022-06-12 13:43:28Z

2

You can use the following query:

var students = await _context.TLibInfo
    .Where(s => s.no == item.no || s.name == item.name && s.no != item.no)
    .ToListAsync();

if (students.Count == 0)
{
   // nothing to update
}
else if (students.Count > 1)
{
    // another student with given name already exists
}
else 
{
    var student = students[0];
    if (student.no != item.no)
    {
       // nothing to update
    }
    else 
    {
        student.name = item.name;

        await _context.SaveChangesasync();
    }
}

But this do not guarantee consistency when another user is also trying to change name for the student at the same time. So better, to start transaction and add Unique constraint on the Name column.

edited Jun 12, 2022 at 13:43

answered Jun 11, 2022 at 10:12

Svyatoslav Danyliv

28.2k4 gold badges24 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kgajjar20 · Accepted Answer · 2022-06-15 10:22:34Z

2

You can do this by using this query :

bool studentExists = await _context.TLibInfo
    .AnyAsync(s => s.no == item.no || s.name.Trim().ToLower() == item.name.Trim().ToLower() && s.no != item.no);

if (studentExists)
{
    //update
}

edited Jun 15, 2022 at 10:22

answered Jun 13, 2022 at 6:49

kgajjar20

3044 silver badges9 bronze badges

Comments

Arthur Edgarov · Accepted Answer · 2022-06-11 09:02:31Z

1

First of all, You could use one query to do that:

var student = await _context.TLibInfo.FirstOrDefaultAsync(s => s.name != item.name && s.no == item.no);
if (student != null)
{
    //update
}

BUT

If you need to have such behavior it would be useful to define a unique index on your database model. More detailed info here. In this Microsoft article, you will find information on how to create an index on the property, but your goal would be to create a unique index on two properties of the Student entity - Name and number.

edited Jun 11, 2022 at 9:02

answered Jun 11, 2022 at 8:56

Arthur Edgarov

7506 silver badges23 bronze badges

Collectives™ on Stack Overflow

Entity Framework Core: How Can I update Entity no duplicate values?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related