Stored procedure still return same result with Entity Framework Core

Question

I have a stored procedure called GetContactsByUserId @userId INT.

I want to call this stored procedure with Entity Framework Core (7.0.0-rc1-final).

The stored procedure return these types in the result:

ContactId INT, ContactName NVARCHAR(200)

I have created in C# the object called - Contact:

[Key]
public int ContactId {get; set;}

public string ContactName {get;set;}

And this DbSet:

public DbSet<Contact> Contacts { get; set; }

I've tried call the stored procedure like this:

_dbContext.Set<Contact>().FromSql("dbo.GetContactsByUserId @userId = {0}", userid);

After first call I get for example 30 rows. I add new records and try again call this procedure with the same parameter and I get 30 rows not 31 rows.

How can I fix this issue?

Dave Ronson · Accepted Answer · 2016-05-01 20:10:52Z

1

Are you sure you called _dbcontext.SaveChanges(); after you added new contacts? That is, are you sure they are in the database?

I mocked up a console example using a stored procedure to list contacts and it works as expected. It returns the correct number of contacts the first time as well as after I add additional contacts.

Here is my ListContacts code in case it helps:

    public static List<Contact> ListContacts()
    {
        var contacts = new List<Contact>();           

        using (var db = new AppDbContext())
        {
            var contactsSQL = db.Set<Contact>().FromSql("dbo.GetContacts");

            foreach (var contactSQL in contactsSQL)
            {
                var contact = new Contact();
                contact.ID = contactSQL.ID;
                contact.Name = contactSQL.Name;
                contacts.Add(contact);
            }

            return contacts;
        }
    }

answered May 1, 2016 at 20:10

Dave Ronson

1487 bronze badges

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

2 Comments

Jenan Over a year ago

Please, what version of EF Core did you use on this sample?

Dave Ronson Over a year ago

The packages I'm using are all "7.0.0-rc1-final"

Collectives™ on Stack Overflow

Stored procedure still return same result with Entity Framework Core

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related