static void Main(string[] args)
{
String connString = @"
Data Source=.;
Initial Catalog=Samochody;
Integrated Security=True
";
DataContext sDataContext = new DataContext(connString);
Table <Samochod> Samochody = sDataContext.GetTable <Samochod>();
if (sDataContext.DatabaseExists())
{
Console.WriteLine("Deleting old database...");
sDataContext.DeleteDatabase();
}
sDataContext.CreateDatabase();
// Insert
Samochod s = new Samochod()
{
ID = 1, IDMarka = 1, Kolor = "Czarny"
};
Samochody.InsertOnSubmit(s);
sDataContext.SubmitChanges();
}
/// <summary>
/// 创建数据库并更新版本
/// </summary>
/// <param name="context"></param>
private static void Create(DataContext context)
{
context.CreateDatabase();
var update = context.CreateDatabaseSchemaUpdater();
update.DatabaseSchemaVersion = Version;
update.Execute();
}
/// <summary>
/// 创建数据库并更新版本
/// </summary>
/// <param name="context"></param>
private static void Create(DataContext context)
{
context.CreateDatabase();
var update = context.CreateDatabaseSchemaUpdater();
update.DatabaseSchemaVersion = Version;
update.Execute();
}
public void CreateDataRepo()
{
using (DataContext context = DbContext.Create())
{
if (!context.DatabaseExists())
{
context.CreateDatabase();
}
}
}
public static DataContext dataContextByName(string db)
{
string conn = Config.CONNSTR(db);
DataContext dc =new DataContext(conn);
if (!dc.DatabaseExists()) {
dc.CreateDatabase();
}
return dc;
}
protected override void CreateDatabase()
{
IConfiguration config = new BasicConfiguration();
var container = config.Container;
DataContext context = container.Resolve <DataContext>();
if (context.DatabaseExists())
{
context.DeleteDatabase();
}
context.CreateDatabase();
}
protected void ReCreateDatabaseFromAttributeMapping(DataContext ctx)
{
bool success = false;
bool retry = false;
int retries = 0;
do
{
try
{
using (ctx)
{
CloseAllOpenConnections(ctx);
ctx.Log = new StringWriter();
if (ctx.DatabaseExists())
{
//drop all connections by disabling multi-user (and immediatly abort all current transactions)
ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE");
ctx.DeleteDatabase();
}
try
{
ctx.CreateDatabase();
}
catch (Exception e)
{
Debug.WriteLine(e);
Debug.WriteLine(ctx.Log);
throw;
}
//re-enable multi-user (again)
ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET MULTI_USER");
success = true;
}
}
catch (SqlException e)
{
retry = false;
if (e.Message.IndexOf("was deadlocked on lock resources with another process and has been chosen as the deadlock victim") > 0)
{
retry = true;
retries++;
}
}
} while (success == false && (retry && retries < 3));
}
protected void ReCreateDatabaseFromAttributeMapping(DataContext ctx)
{
bool success = false;
bool retry = false;
int retries = 0;
do
{
try
{
using (ctx)
{
CloseAllOpenConnections(ctx);
ctx.Log = new StringWriter();
if (ctx.DatabaseExists())
{
//drop all connections by disabling multi-user (and immediatly abort all current transactions)
ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE");
ctx.DeleteDatabase();
}
try
{
ctx.CreateDatabase();
}
catch (Exception e)
{
Debug.WriteLine(e);
Debug.WriteLine(ctx.Log);
throw;
}
//re-enable multi-user (again)
ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET MULTI_USER");
success = true;
}
}
catch (SqlException e)
{
retry = false;
if (e.Message.IndexOf("was deadlocked on lock resources with another process and has been chosen as the deadlock victim") > 0)
{
retry = true;
retries++;
}
}
} while (success == false && (retry && retries < 3));
}
void ValidateDatabase()
{
if (!DataBaseContext.DatabaseExists())
{
DataBaseContext.CreateDatabase();
CreateIndices();
}
else
{
DataBaseContext.Connection.Open();
}
if (!TableExists())
{
CreateTable();
CreateIndices();
}
}
private static void ClearTpDB(DataContext tpDatabaseDataContext)
{
if (!tpDatabaseDataContext.DatabaseExists())
{
tpDatabaseDataContext.CreateDatabase();
tpDatabaseDataContext.SubmitChanges();
}
else
{
tpDatabaseDataContext.ExecuteCommand("delete from Project");
tpDatabaseDataContext.ExecuteCommand("delete from TpUser");
tpDatabaseDataContext.ExecuteCommand("delete from General");
tpDatabaseDataContext.ExecuteCommand("delete from MessageUid");
tpDatabaseDataContext.ExecuteCommand("delete from PluginProfile");
tpDatabaseDataContext.ExecuteCommand("delete from Revision");
}
}
private static void CreateDatabase()
{
DataContext.CreateDatabase();
}
/// <summary>Run operation.</summary>
public void Run(enumRun mode)
{
// Validate application configuration file.
if(String.IsNullOrEmpty(_paramGetStatusesSince) || String.IsNullOrEmpty(_paramGetStatusesCount)) {
EventLog.WriteEntry(logName, "Application Error: Missing values from configuration file.", EventLogEntryType.Error);
return;
}
// Init database.
_dbContext = new BaseDataContext(_dbConnectionString);
if(!_dbContext.DatabaseExists()) {
_dbContext.CreateDatabase();
}
// Create (INSERT) default data to database.
if(mode == enumRun.LoadData) {
CreateStatusesDefault();
Console.WriteLine("\nLoaded data successfully.");
} else if(mode == enumRun.LoadData) {
Console.WriteLine("\nCannot load data because it exists. If you want to try again, then you must either drop the database or delete all the records.");
}
// Iterate and process users.
TwitterStatus userStatus = null;
string userUrlGetStatuses = String.Empty;
var userIds = _paramGetStatusesUserValue.RemoveWhitespaces().Split(new char[] {','}, StringSplitOptions.RemoveEmptyEntries);
for(int i = 0;i < userIds.Length;i += 1) {
userUrlGetStatuses = String.Empty;
// Get (SELECT) status, most recent.
userStatus = GetStatusLatest(userIds[i]);
// Validate status.
if(userStatus != null) {
userUrlGetStatuses = _urlGetStatuses.AppendQueryString(String.Concat(_paramGetStatusesSince, "=", userStatus.Id));
} else {
userUrlGetStatuses = _urlGetStatuses.AppendQueryString(String.Concat(_paramGetStatusesCount, "=", _paramDataStatusesHistory));
}
// Create (INSERT) statue from XML.
CreateStatus(userUrlGetStatuses.AppendQueryString(String.Concat(_paramGetStatusesUser, "=", userIds[i])));
}
// Remove (DELETE) extra statuses based on maximum length.
RemoveStatuses(_paramDataStatusesHistory);
// Submit data changes.
_dbContext.SubmitChanges();
}
/// <summary>Run operation.</summary>
public void Run(enumRun mode)
{
// Init database.
_dbContext = new BaseDataContext(_dbConnectionString);
if(!_dbContext.DatabaseExists()) {
_dbContext.CreateDatabase();
}
// Get (SELECT) locations from database.
var locations = GetLocations();
int locationsLength = locations.Count();
// Create (INSERT) default data to database.
if(mode == enumRun.LoadData && (locations == null || locationsLength <= 0)) {
locations = CreateLocationsDefault();
Console.WriteLine("\nLoaded data successfully.");
} else if(mode == enumRun.LoadData) {
Console.WriteLine("\nCannot load data because it exists. If you want to try again, then you must either drop the database or delete all the records.");
}
// Process condition from each location.
for(int i = 0;i < locationsLength;i += 1) {
// Create (INSERT) condition from XML.
CreateConditions(locations[i]);
// Remove (DELETE) extra conditions based on maximum length.
RemoveConditions(locations[i], _paramConditionHistory);
}
// Remove (DELETE) extra conditions based on maximum length.
RemoveConditions(_paramConditionHistory);
// Submit data changes.
_dbContext.SubmitChanges();
}
