コード例 #1
0
        public void IncorrectSettingsType()
        {
            MuscleLogContext ctx = new MuscleLogContext("metadata=res://*/Models.MuscleLogModel.csdl|res://*/Models.MuscleLogModel.ssdl|res://*/Models.MuscleLogModel.msl;provider=System.Data.SqlClient;provider connection string='data source=MAX-PC;Initial Catalog=muscle-log;User ID=Max-PC;integrated security=SSPI;multipleactiveresultsets=True;application name=EntityFramework'");

            ml_Settings test = new ml_Settings();
            test.StringValue = "test";
            test.PropertyName = "incorrectTypeSetting";
            ctx.ml_Settings.Add(test);
            ctx.SaveChanges();
            Assert.Throws(typeof(SettingsTypeException), delegate { muscle_log.Config.GetIntVal("incorrectTypeSetting", ctx); });

            test = null;
            test = ctx.ml_Settings.Where(s => s.PropertyName == "incorrectTypeSetting").FirstOrDefault();
            ctx.ml_Settings.Remove(test);
            ctx.SaveChanges();

            ctx.Dispose();
        }
コード例 #2
0
        /// <summary>
        /// saves the current user with all its values in the database
        /// </summary>
        public void Save()
        {
            var user = new ml_User();
            user.ID = ID;
            user.userStatus = (int)userStatus;
            user.userName = userName;
            user.userEmail = userEmail;

            using (var context = new MuscleLogContext())
            {
                if (user.ID > 0)
                {
                    context.ml_User.Attach(user);
                    context.Entry(user).State = System.Data.Entity.EntityState.Modified;
                }
                else
                {
                    context.ml_User.Add(user);
                }
                context.SaveChanges();
            }
        }