“Specified method is not supported.” in entity framework

Question

this is my entity class listed as

public partial class NerdDinnerEntities : ObjectContext
    {
        #region Constructors
 

        public NerdDinnerEntities(string connectionString)
            : base(connectionString, "NerdDinnerEntities")
        {
            try
            {
                ObjectContext oc = new ObjectContext(connectionString);
 
               oc.Connection.ChangeDatabase("NERDDINNER1");
               oc.AcceptAllChanges();
                this.ContextOptions.LazyLoadingEnabled = true;
                OnContextCreated();
            }
            catch (Exception ex) { }
        }
 

        #endregion
 
        #region Partial Methods
 
        partial void OnContextCreated();
 
        #endregion
 
        #region ObjectSet Properties
 
        /// 
        /// No Metadata Documentation available.
        /// 
        public ObjectSet Dinners
        {
            get
            {
                if ((_Dinners == null))
                {
                    _Dinners = base.CreateObjectSet("Dinners");
                }
                return _Dinners;
            }
        }
        private ObjectSet _Dinners;
 
        /// 
        /// No Metadata Documentation available.
        /// 
        public ObjectSet RSVPs
        {
            get
            {
                if ((_RSVPs == null))
                {
                    _RSVPs = base.CreateObjectSet("RSVPs");
                }
                return _RSVPs;
            }
        }
        private ObjectSet _RSVPs;
 
        /// 
        /// No Metadata Documentation available.
        /// 
        public ObjectSet sysdiagrams
        {
            get
            {
                if ((_sysdiagrams == null))
                {
                    _sysdiagrams = base.CreateObjectSet("sysdiagrams");
                }
                return _sysdiagrams;
            }
        }
        private ObjectSet _sysdiagrams;
 
        #endregion
        #region AddTo Methods
 
        /// 
        /// Deprecated Method for adding a new object to the Dinners EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
        /// 
        public void AddToDinners(Dinner dinner)
        {
            base.AddObject("Dinners", dinner);
        }
 
        /// 
        /// Deprecated Method for adding a new object to the RSVPs EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
        /// 
        public void AddToRSVPs(RSVP rSVP)
        {
            base.AddObject("RSVPs", rSVP);
        }
 
        /// 
        /// Deprecated Method for adding a new object to the sysdiagrams EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
        /// 
        public void AddTosysdiagrams(sysdiagram sysdiagram)
        {
            base.AddObject("sysdiagrams", sysdiagram);
        }
 
        #endregion
    }
 

and these is my web.config file as

<add name="NerdDinnerEntities" connectionString="metadata=res://*/Models.NerdDinner.csdl|res://*/Models.NerdDinner.ssdl|res://*/Models.NerdDinner.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=@;Database=NERDDINNER;User ID=@;Password=@@@;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClients" />

 

and i am getting error in this line as

oc.Connection.ChangeDatabase("NERDDINNER1");

 
<big> Specified method is not supported.</big>
 
i do not know how to proceed can u give ur valuable sugessions

Answer 1

Does that database exist? 

Answer 2

s i have that database  with that connection string

Answer 3

Hi Gowthammanju,

I think you can try this: http://stackoverflow.com/questions/11734641/specified-method-is-not-supported-in-entity-framework

Have a nice day.

---

Alexander Sun [MSFT]
MSDN Community Support | Feedback to us