How to redeem data that was saved in the bank during a creation process

Asked

Viewed 77 times

3

In some Orms Nodejs I have this feature. However, I would like to know how to rescue an entity that was persisted in the bank?

For example: User has an attribute ID. If I return the item, the ID what has been persisted does not come within item.

I would like to return something from _context of what was persisted, so that I come to rescue Id.

Follows a generic model I’m using:

    public T Create(T item)
    {
        _dataset.Add(item);
        _context.SaveChanges();
        return item;   
    }

Follows class with basic methods:

public class GenericRepository<T> : IRepository<T> where T : BaseEntity
    {
        protected readonly AimbraDocContext _context;
        private readonly DbSet<T> _dataset;

        public GenericRepository(AimbraDocContext context)
        {
            _context = context;
            _dataset = _context.Set<T>();
        }

        public T Create(T item)
        {
            _dataset.Add(item);
            _context.SaveChanges();
            return item;
        }

        public void Delete(long id)
        {
            var result = _dataset.SingleOrDefault(i => i.Id.Equals(id));
            if (result != null)
            {
                _dataset.Remove(result);
                _context.SaveChanges();
            }
        }

        public bool Exist(long? id)
        {
            return _dataset.Any(i => i.Id.Equals(id));
        }

        public List<T> FindAll()
        {
            return _dataset.ToList();
        }

        public T FindById(long id)
        {
            var result = _dataset.SingleOrDefault(i => i.Id.Equals(id));
            if (result == null) return null;
            return result;
        }

        public T Update(T t)
        {
            if (!Exist(t.Id)) return null;
            var result = _dataset.SingleOrDefault(i => i.Id.Equals(t.Id));
            _context.Entry(result).CurrentValues.SetValues(t);
            _context.SaveChanges();
            return t;

        }
    }
c# entity-framework asp.net-core entity-framework-core
  • 2

    The ID is auto increment in your base?

  • This... is yes... I defined it with the Dataanottation [Key] in na Prop Id.

  • 1

    You have to put all the code Create is very strange

  • 1

    If you are using entity framework and auto increment field, the item.ID should be completed after the SaveChanges. Which database are you using? And post the class code User.

  • It is a generic class. I will update and if you have any changes, feel free to do with the observations. I am starting now in the language...

  • Your question has been answered here. In summary, EF6 already implements Insert with SCOPE_IDENTITY, just capture the object id.

  • Ah... thank you! I got it here! :)

  • Someone can answer in Portuguese. I can’t close the question, because the platform requires an answer in Portuguese.

Show 3 more comments

1 answer

0

What you can do is instead of using Id as int you can use the GUID that will always give you a string.

   Id = Guid.NewGuid();

This way you will always have a unique identifier and know what it is before registering in the bank.

Browser other questions tagged c# entity-framework asp.net-core entity-framework-core

You are not signed in. Login or sign up in order to post.