forked from ThatRendle/Simple.Data
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSqlConnectionProvider.cs
More file actions
83 lines (68 loc) · 2.2 KB
/
SqlConnectionProvider.cs
File metadata and controls
83 lines (68 loc) · 2.2 KB
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
using System;
using System.ComponentModel.Composition;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Linq;
using Simple.Data.Ado;
using Simple.Data.Ado.Schema;
namespace Simple.Data.SqlServer
{
[Export(typeof(IConnectionProvider))]
[Export("System.Data.SqlClient", typeof(IConnectionProvider))]
public class SqlConnectionProvider : IConnectionProvider
{
private string _connectionString;
public SqlConnectionProvider()
{
}
public SqlConnectionProvider(string connectionString)
{
_connectionString = connectionString;
}
public IDbConnection CreateConnection()
{
return new SqlConnection(_connectionString);
}
public ISchemaProvider GetSchemaProvider()
{
return new SqlSchemaProvider(this);
}
public void SetConnectionString(string connectionString)
{
_connectionString = connectionString;
}
public string ConnectionString
{
get { return _connectionString; }
}
public string GetIdentityFunction()
{
return "SCOPE_IDENTITY()";
}
public bool TryGetNewRowSelect(Table table, ref string insertSql, out string selectSql)
{
var identityColumn = table.Columns.FirstOrDefault(col => col.IsIdentity);
if (identityColumn == null)
{
selectSql = null;
return false;
}
selectSql = "select * from " + table.QualifiedName + " where " + identityColumn.QuotedName +
" = SCOPE_IDENTITY()";
return true;
}
public bool SupportsCompoundStatements
{
get { return true; }
}
public bool SupportsStoredProcedures
{
get { return true; }
}
public IProcedureExecutor GetProcedureExecutor(AdoAdapter adapter, ObjectName procedureName)
{
return new ProcedureExecutor(adapter, procedureName);
}
}
}