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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Data.SqlClient;
using System.Data.SQLite;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Tango.Core
{
/// <summary>
/// Represents an SQL data source.
/// </summary>
public class DataSource
{
//private static bool _has_provider;
/// <summary>
/// Gets or sets the type of source.
/// </summary>
public DataSourceType Type { get; set; }
/// <summary>
/// Gets or sets the address.
/// </summary>
public String Address { get; set; }
/// <summary>
/// Gets or sets the catalog name.
/// </summary>
public String Catalog { get; set; }
/// <summary>
/// Gets or sets a value indicating whether to use integrated security.
/// </summary>
public bool IntegratedSecurity { get; set; }
/// <summary>
/// Gets or sets the user name to use if <see cref="IntegratedSecurity"/> is false.
/// </summary>
public String UserName { get; set; }
/// <summary>
/// Gets or sets the password to use if <see cref="IntegratedSecurity"/> is false.
/// </summary>
public String Password { get; set; }
/// <summary>
/// Initializes a new instance of the <see cref="DataSource"/> class.
/// </summary>
public DataSource()
{
Type = DataSourceType.SQLServer;
Address = "localhost\\SQLEXPRESS";
Catalog = "Tango";
IntegratedSecurity = true;
UserName = String.Empty;
Password = String.Empty;
}
/// <summary>
/// Creates a DBConnection instance which represents this data source.
/// </summary>
/// <returns></returns>
public DbConnection ToConnection()
{
switch (Type)
{
case DataSourceType.SQLite:
var connection = new SQLiteConnection()
{
ConnectionString = new SQLiteConnectionStringBuilder() { DataSource = Path.GetFullPath(Address), ForeignKeys = true }.ConnectionString
};
return connection;
case DataSourceType.MDF:
if (IntegratedSecurity)
{
return new SqlConnection(String.Format("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFileName={0};Initial Catalog={1};Integrated Security=True;MultipleActiveResultSets=True;App=EntityFramework", Path.GetFullPath(Address), Catalog));
}
else
{
return new SqlConnection(String.Format("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFileName={0};Initial Catalog={1};Integrated Security=False;User Id={2};Password={3};MultipleActiveResultSets=True;App=EntityFramework", Path.GetFullPath(Address), Catalog, UserName, Password));
}
case DataSourceType.SQLServer:
if (IntegratedSecurity)
{
return new SqlConnection(String.Format("Data Source={0};Initial Catalog={1};Integrated Security=True;MultipleActiveResultSets=True;App=EntityFramework", Address, Catalog));
}
else
{
return new SqlConnection(String.Format("Data Source={0};Initial Catalog={1};Integrated Security=False;User Id={2};Password={3};MultipleActiveResultSets=True;App=EntityFramework", Address, Catalog, UserName, Password));
}
case DataSourceType.Azure:
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = Address;
builder.InitialCatalog = Catalog;
builder.UserID = UserName;
builder.Password = Password;
builder.IntegratedSecurity = false;
//builder.TrustServerCertificate = true;
builder.MultipleActiveResultSets = true;
builder.ApplicationName = "EntityFramework";
//builder.ConnectTimeout = 15;
builder.Authentication = SqlAuthenticationMethod.ActiveDirectoryPassword;
SqlConnection sqlConnection = new SqlConnection(builder.ConnectionString);
return sqlConnection;
default:
return null;
}
}
}
}
|
