markus / ConvertService / ServiceBase / Markus.Service.DataBase / MarkusEntities.cs @ b92f142f
이력 | 보기 | 이력해설 | 다운로드 (2.21 KB)
1 | 53c9637d | taeseongkim | |
---|---|---|---|
2 | namespace Markus.Service.DataBase |
||
3 | { |
||
4 | using System; |
||
5 | using System.Data.Entity; |
||
6 | using System.Data.Entity.Core.EntityClient; |
||
7 | using System.Data.Entity.Infrastructure; |
||
8 | using System.Data.SqlClient; |
||
9 | |||
10 | public partial class MarkusEntities : DbContext |
||
11 | { |
||
12 | private const string providerName = "System.Data.SqlClient"; |
||
13 | private const string MarkusMeta = @"res://*/markusModel.csdl|res://*/markusModel.ssdl|res://*/markusModel.msl"; |
||
14 | |||
15 | public MarkusEntities(string ConnectionString) |
||
16 | : base(ConnectionStringBuilder(ConnectionString).ToString()) |
||
17 | { |
||
18 | 06f13e11 | taeseongkim | this.Database.CommandTimeout = 60; |
19 | 53c9637d | taeseongkim | } |
20 | cdfb57ff | taeseongkim | |
21 | 53c9637d | taeseongkim | private static EntityConnectionStringBuilder ConnectionStringBuilder(string ConnectionString) |
22 | { |
||
23 | //SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(string.Format(Properties.Settings.Default.ProjectCIConnectionString, "DeepView")); |
||
24 | SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(ConnectionString); |
||
25 | return EntityConnectionBuilder(_bl, MarkusMeta); |
||
26 | } |
||
27 | |||
28 | private static EntityConnectionStringBuilder |
||
29 | EntityConnectionBuilder(SqlConnectionStringBuilder SqlStringBuilder, string EntityMetaData) |
||
30 | { |
||
31 | string providerString = SqlStringBuilder.ToString(); |
||
32 | |||
33 | EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(); |
||
34 | |||
35 | 06f13e11 | taeseongkim | |
36 | 53c9637d | taeseongkim | entityBuilder.Provider = providerName; |
37 | entityBuilder.ProviderConnectionString = providerString; |
||
38 | entityBuilder.Metadata = EntityMetaData; |
||
39 | |||
40 | 06f13e11 | taeseongkim | //Console.WriteLine(entityBuilder.ToString()); |
41 | |||
42 | 53c9637d | taeseongkim | using (EntityConnection conn = |
43 | new EntityConnection(entityBuilder.ToString())) |
||
44 | { |
||
45 | try |
||
46 | { |
||
47 | conn.Open(); |
||
48 | //Console.WriteLine("Just testing the connection."); |
||
49 | conn.Close(); |
||
50 | } |
||
51 | catch (Exception ex) |
||
52 | { |
||
53 | System.Diagnostics.Debug.WriteLine(ex.ToString()); |
||
54 | throw ex; |
||
55 | } |
||
56 | |||
57 | } |
||
58 | |||
59 | return entityBuilder; |
||
60 | } |
||
61 | |||
62 | } |
||
63 | } |