db.table doesn't bring updated value ,When I update table manually from sql database

Question

I am working on mvc c# , with sql database at backend. My problem is when I update a table's data manually from sql table at backend. It is not updated on the frontend until I open the website again after closing the webpage.

Here is the Image of database table where am updating it manually.

here am retrieving data from database.

  public ActionResult AddQuiz()
    {

        ViewBag.quizes_List = db.EntityFrameWorkConnection.Zasa_Quiz.OrderByDescending(mm => mm.quiz_code).ToList();
        return View();
    }

This is where am using my ViewBag to display quizes list

 @foreach (var item in @ViewBag.quizes_List)
                        {
                            <tr>
                                <td>
                                    <span class="badge bg-blue">@item.quiz_code</span>
                                </td>
                                <td>
                                    @item.quiz_title
                                </td>

                                <td><span class="badge bg-blue">@item.quiz_date.ToString().Substring(0, 10)</span></td>
                            </tr>
                        }

EntityFrameWorkConnection is in constants class. and db is declared like this in controller: and all this is working fine.

 private static Constants db = new Constants();



 public class Constants
{
    public ZASA_AK_DBEntity EntityFrameWorkConnection = new ZASA_AK_DBEntity();
    public SqlConnection ADOConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["adocon"].ConnectionString);
    public string ConnectionString = ConfigurationManager.ConnectionStrings["adocon"].ConnectionString;

}

have you check the viewbag using debugger that list items are coming in it? — Vishvadeep singh
– Vishvadeep singh, Commented Nov 16, 2017 at 12:33
Are you say that refreshing the page is not working? In which case it may be a caching issue. — user3559349
– user3559349, Commented Nov 16, 2017 at 12:34
Does F5 or CTRL-F5 update the value? You now it's not going to automatically appear right? What you're seeing is a static page that won't refresh unless you tell it to — Nick.Mc
– Nick.Mc, Commented Nov 16, 2017 at 12:38
Yes i have debugged it. actually db.entityframework thing is not bringing the updated value. i have tried it using a separate list too. it stays same. — Zainab Jamil
– Zainab Jamil, Commented Nov 16, 2017 at 12:39
No not cache issue. have tested it using breakpoints. list brings old value. — Zainab Jamil
– Zainab Jamil, Commented Nov 16, 2017 at 12:40

Navin Chandran · Accepted Answer · 2017-11-16 13:41:10Z

2

Entity framework catches the data. You have to use Using block.

using(var context = new DBEntities())
{

}

answered Nov 16, 2017 at 13:41

Navin Chandran

517 bronze badges

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

5 Comments

Zainab Jamil Over a year ago

It is behaving the same. no difference

Navin Chandran Over a year ago

change the structure so that on each request new object of context is created.

Navin Chandran Over a year ago

when you are accessing with the help of "db" you will get catched data in entity. you will get updated data with the help of new object of entity.

Zainab Jamil Over a year ago

I have tried entries.reload(). its working and giving me updated data !

Gert Arnold Over a year ago

Of course this is the only right answer. Use new context instance, don't Reload.

Ram Venkat · Accepted Answer · 2017-11-16 12:53:41Z

1

@Zainab The snippet you provided doesn't have any refresh or dynamic data retrieval. The AddQuiz() method retrieves data and calls the View. Now, if you change something in Backend, view should be refreshed or AddQuiz() should be called again to get the Updated Data.

Try .Reload() method on your entity and if that doesn't fix it, try disposing your dbcontext as soon as you are finished with the method call and create a new dbcontext everytime.

edited Nov 16, 2017 at 12:53

answered Nov 16, 2017 at 12:40

Ram Venkat

941 silver badge11 bronze badges

1 Comment

Zainab Jamil Over a year ago

It doesnot brings data on refresh actually. Am refreshing the page and it calls AddQuiz() again. But data is not changed. am not concerned with refreshing it dynamically actually.

Collectives™ on Stack Overflow

db.table doesn't bring updated value ,When I update table manually from sql database

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related