Caching in MVC Application With Entity Framework Using Query Notification

Sign in to leave a comment.

• 

  Ajeet Mishra7y agoPosted Jan 18, 2019, 5:32 AM

  Hey jignesh can tell me why this line giving exception SqlCommand command = new SqlCommand(((System.Data.Objects.ObjectQuery).... in this line
  • 

    Jignesh Trivedi7y agoPosted Jan 18, 2019, 9:33 AM

    Hi check your database setting. Is service broker is enabled?
  • 

    Jignesh Trivedi7y agoPosted Jan 18, 2019, 9:35 AM

    Also refer article, it help you understand what kind of query we can write for notification. https://www.c-sharpcorner.com/UploadFile/ff2f08/query-notification-in-sql-server/
• TK

  tushar kshirsagar9y agoPosted Jul 9, 2017, 8:42 AM

  This example do not work for ENABLE_BROKER for Azure; So useless but for full VM it may work not checked !
  • 

    Jignesh Trivedi9y agoPosted Jul 10, 2017, 1:30 AM

    Even I did not check this example with Azure. Let me check and get back to you.
• SM

  sonubaba manani10y agoPosted Jan 12, 2016, 2:21 AM

  Unable to cast object of type 'System.Data.Entity.DbSe to type 'System.Data.Entity.Core.Objects.ObjectQuery
  • 

    Jignesh Trivedi10y agoPosted Jan 12, 2016, 10:45 PM

    In which line you get error? hope you use latest Entity framework version.
  • 

    Kailash Polai8y agoPosted Jan 5, 2018, 7:50 AM

    SqlCommand command = new SqlCommand(((System.Data.Objects.ObjectQuery).... in this line
  • 

    Vinay Singh6y agoPosted Aug 19, 2020, 3:11 AM

    Hi Add reference to System.Data.Entity
• SM

  sonubaba manani10y agoPosted Jan 12, 2016, 2:21 AM

  i used your code but getting error
• SM

  sonubaba manani10y agoPosted Jan 12, 2016, 2:20 AM

  good article!!!!