blob: 4c703a96b0e7ceb6912e3225969fcdc5a8742bfa (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
using System;
using System.Collections.Generic;
using System.Data.SQLite;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.Core;
using Tango.Settings;
namespace Tango.BL
{
public partial class ObservablesContext
{
/// <summary>
/// Initializes a new instance of the <see cref="ObservablesContext" /> class.
/// </summary>
/// <param name="path">The server file path.</param>
/// <param name="isFile">if set to <c>true</c> will try to connect to an .mdf file.</param>
public ObservablesContext(String path) : base(ComposeConnectionString(path))
{
}
/// <summary>
/// Initializes a new instance of the <see cref="ObservablesContext"/> class.
/// </summary>
/// <param name="sqliteConnection">The SQLite connection.</param>
public ObservablesContext(SQLiteConnection sqliteConnection) : base(sqliteConnection, true)
{
}
/// <summary>
/// Composes the connection string.
///</summary>
/// <param name="source">The source.</param>
/// <param name="isFile">if set to <c>true</c> [is file].</param>
/// <returns></returns>
private static String ComposeConnectionString(String source)
{
if (!File.Exists(source))
{
return String.Format("Data Source={0};Initial Catalog=Tango;Integrated Security=True;", source);
}
else
{
return String.Format("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFileName={0};Initial Catalog=Tango;Integrated Security=True;MultipleActiveResultSets=True;App=EntityFramework", Path.GetFullPath(source));
}
}
/// <summary>
/// Creates a default remote database context by the address specified in <see cref="SettingsManager.Default.DataBase.SQLServerAddress" />.
/// </summary>
/// <returns></returns>
public static ObservablesContext CreateDefault()
{
return CreateDefault(SettingsManager.Default.GetOrCreate<CoreSettings>().DataBaseSource);
}
/// <summary>
/// Creates a default remote database context by the address specified in <see cref="SettingsManager.Default.DataBase.SQLServerAddress" />.
/// </summary>
/// <returns></returns>
public static ObservablesContext CreateDefault(String dataSource)
{
var source = dataSource;
if (File.Exists(source) && Path.GetExtension(source).ToLower() == ".db")
{
var connection = new SQLiteConnection()
{
ConnectionString = new SQLiteConnectionStringBuilder() { DataSource = Path.GetFullPath(source), ForeignKeys = true }.ConnectionString
};
return new ObservablesContext(connection);
}
else
{
return new ObservablesContext(source);
}
}
/// <summary>
/// Creates a default remote database context by the address specified in <see cref="SettingsManager.Default.DataBase.SQLServerAddress" />.
/// </summary>
/// <returns></returns>
public static ObservablesContext CreateDefaultForWeb()
{
return new ObservablesContext("localhost\\SQLTWINE");
}
}
}
|
