Exemple #1
0
		private void SaveExceptionLogEntity(ErrorLog entity)
		{
			using (LoggerContext db = new LoggerContext())
			{
				db.ErrorLogs.Add(entity);
				db.SaveChanges();
			}
		}
Exemple #2
0
		private void SaveDebugLogEntity(DebugLog entity)
		{
			using (LoggerContext db = new LoggerContext())
			{
				db.DebugLogs.Add(entity);
				db.SaveChanges();
			}
		}
Exemple #3
0
		static void Main(string[] args)
		{
			DbConfigManager.SetParameters(args);
			//	Generate IMigrationMetadata.Target 
			using (var db = new DVSContext())
			{
				var st = ModelHelper.GenerateModel(db);
			}

			try
			{
				Stopwatch sw = new Stopwatch();
				sw.Start();
				Console.WriteLine("Start DVS.Database project.");

				foreach (var usedContext in DbConfigManager.UsedContexts)
				{
					DbContext dataContext;
					if (usedContext.Key == "DVSContext")
						dataContext = new DVSContext();
					else if (usedContext.Key == "TaskQueueContext")
						dataContext = new TaskQueueContext();
					else if (usedContext.Key == "LoggerContext")
						dataContext = new LoggerContext();
					else
						throw new NotSupportedException(usedContext.Key);

					if (!DbConfigManager.IsGenerateScriptOnly)
					{
						DatabaseHelper.CreatedDatabase(dataContext, usedContext.Value);

						dataContext.Database.CompatibleWithModel(true);
					}
					else
					{
						string sqlUpdate = DatabaseHelper.GenetateSqlUpdate(dataContext, usedContext.Value);
						string sqlRollback = DatabaseHelper.GenetateSqlRollback(dataContext, usedContext.Value);

						File.WriteAllText(usedContext.Key + "Update_" + usedContext.Key + ".sql", sqlUpdate + Environment.NewLine + "GO");
						//		File.WriteAllText(usedContext.Key + "Rollback_" + usedContext.Key + ".sql", sqlRollback + Environment.NewLine + "GO");
					}
				}

				sw.Stop();
				Console.WriteLine(String.Format("End at {0} s", sw.ElapsedMilliseconds / 1000));
			}
			catch (Exception ex)
			{
				Console.WriteLine(String.Format("Error [{0}], [{1}]", ex.Message, ex.ToString()));
			}
		}