質問編集履歴
3
手順にイメージ追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -150,7 +150,13 @@
|
|
150
150
|
|
151
151
|
---
|
152
152
|
|
153
|
+
![イメージ説明](b543e4d558e7c4c302a61bfdc583040a.png)
|
154
|
+
|
155
|
+
![イメージ説明](84b646eb36ac639dece425484fc67271.png)
|
156
|
+
|
153
157
|
ADO.NET Entity Data Modelを作成→データベースからCode First選択して作成
|
158
|
+
|
159
|
+
|
154
160
|
|
155
161
|
|
156
162
|
|
2
用意されているコードの追記。タグからASP.NETの除外。
test
CHANGED
File without changes
|
test
CHANGED
@@ -4,7 +4,7 @@
|
|
4
4
|
|
5
5
|
insert時、テーブルのカラムに設定したDEFAULT値を反映させる
|
6
6
|
|
7
|
-
下記手順VBコードで.TRADE_QUANTITY = 1と書かなくてもT_TRADEのTRADE_QUANTITYに1が挿入される
|
7
|
+
下記手順VBコードで.TRADE_QUANTITY = 1と書かなくてもT_TRADEのTRADE_QUANTITYにカラムのDEFAULT値である1が挿入される
|
8
8
|
|
9
9
|
|
10
10
|
|
@@ -23,6 +23,126 @@
|
|
23
23
|
EntityFramework6.2.0
|
24
24
|
|
25
25
|
|
26
|
+
|
27
|
+
用意コード
|
28
|
+
|
29
|
+
---
|
30
|
+
|
31
|
+
DbModel.vb
|
32
|
+
|
33
|
+
```VB.NET
|
34
|
+
|
35
|
+
Imports System.Data.Entity
|
36
|
+
|
37
|
+
|
38
|
+
|
39
|
+
Partial Public Class DbModel
|
40
|
+
|
41
|
+
Inherits DbContext
|
42
|
+
|
43
|
+
|
44
|
+
|
45
|
+
Public Sub New()
|
46
|
+
|
47
|
+
MyBase.New("name=DbModel")
|
48
|
+
|
49
|
+
End Sub
|
50
|
+
|
51
|
+
|
52
|
+
|
53
|
+
Public Overridable Property T_TRADE As DbSet(Of T_TRADE)
|
54
|
+
|
55
|
+
|
56
|
+
|
57
|
+
Protected Overrides Sub OnModelCreating(ByVal modelBuilder As DbModelBuilder)
|
58
|
+
|
59
|
+
modelBuilder.Entity(Of T_TRADE)() _
|
60
|
+
|
61
|
+
.Property(Function(e) e.USER_ID) _
|
62
|
+
|
63
|
+
.IsUnicode(False)
|
64
|
+
|
65
|
+
|
66
|
+
|
67
|
+
modelBuilder.Entity(Of T_TRADE)() _
|
68
|
+
|
69
|
+
.Property(Function(e) e.USER_NAME) _
|
70
|
+
|
71
|
+
.IsUnicode(False)
|
72
|
+
|
73
|
+
End Sub
|
74
|
+
|
75
|
+
End Class
|
76
|
+
|
77
|
+
```
|
78
|
+
|
79
|
+
|
80
|
+
|
81
|
+
T_TRADE.vb
|
82
|
+
|
83
|
+
```VB.NET
|
84
|
+
|
85
|
+
Imports System.ComponentModel.DataAnnotations
|
86
|
+
|
87
|
+
Imports System.ComponentModel.DataAnnotations.Schema
|
88
|
+
|
89
|
+
|
90
|
+
|
91
|
+
<Table("TEST.T_TRADE")>
|
92
|
+
|
93
|
+
Partial Public Class T_TRADE
|
94
|
+
|
95
|
+
<Key>
|
96
|
+
|
97
|
+
Public Property TRADE_NO As Long
|
98
|
+
|
99
|
+
|
100
|
+
|
101
|
+
<Required>
|
102
|
+
|
103
|
+
<StringLength(10)>
|
104
|
+
|
105
|
+
Public Property USER_ID As String
|
106
|
+
|
107
|
+
|
108
|
+
|
109
|
+
<Required>
|
110
|
+
|
111
|
+
<StringLength(30)>
|
112
|
+
|
113
|
+
Public Property USER_NAME As String
|
114
|
+
|
115
|
+
|
116
|
+
|
117
|
+
Public Property TRADE_QUANTITY As Long
|
118
|
+
|
119
|
+
End Class
|
120
|
+
|
121
|
+
```
|
122
|
+
|
123
|
+
|
124
|
+
|
125
|
+
テーブル
|
126
|
+
|
127
|
+
T_TRADE構成
|
128
|
+
|
129
|
+
```SQL
|
130
|
+
|
131
|
+
CREATE TABLE [TEST].[T_TRADE] (
|
132
|
+
|
133
|
+
[TRADE_NO] BIGINT IDENTITY (1, 1) NOT NULL,
|
134
|
+
|
135
|
+
[USER_ID] VARCHAR (10) NOT NULL,
|
136
|
+
|
137
|
+
[USER_NAME] VARCHAR (30) NOT NULL,
|
138
|
+
|
139
|
+
[TRADE_QUANTITY] BIGINT CONSTRAINT [DF_T_TRADE_ESTIMATES_QUANTITY] DEFAULT ((1)) NOT NULL,
|
140
|
+
|
141
|
+
CONSTRAINT [PK_T_TRADE] PRIMARY KEY CLUSTERED ([TRADE_NO] ASC)
|
142
|
+
|
143
|
+
);
|
144
|
+
|
145
|
+
```
|
26
146
|
|
27
147
|
|
28
148
|
|
@@ -52,29 +172,11 @@
|
|
52
172
|
|
53
173
|
```
|
54
174
|
|
55
|
-
T_TRADE構成
|
56
|
-
|
57
|
-
```SQL
|
58
|
-
|
59
|
-
CREATE TABLE [TEST].[T_TRADE] (
|
60
|
-
|
61
|
-
[TRADE_NO] BIGINT IDENTITY (1, 1) NOT NULL,
|
62
|
-
|
63
|
-
[USER_ID] VARCHAR (10) NOT NULL,
|
64
|
-
|
65
|
-
[USER_NAME] VARCHAR (30) NOT NULL,
|
66
|
-
|
67
|
-
[TRADE_QUANTITY] BIGINT CONSTRAINT [DF_T_TRADE_ESTIMATES_QUANTITY] DEFAULT ((1)) NOT NULL,
|
68
|
-
|
69
|
-
CONSTRAINT [PK_T_TRADE] PRIMARY KEY CLUSTERED ([TRADE_NO] ASC)
|
70
|
-
|
71
|
-
);
|
72
|
-
|
73
|
-
```
|
74
175
|
|
75
176
|
|
76
177
|
|
178
|
+
|
77
|
-
結果
|
179
|
+
結果 T_TRADE
|
78
180
|
|
79
181
|
TRADE_NO 1
|
80
182
|
|
1
環境の詳細を追記しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -12,11 +12,13 @@
|
|
12
12
|
|
13
13
|
---
|
14
14
|
|
15
|
-
VisualStudio2017
|
15
|
+
VisualStudio2017 15.5.2
|
16
16
|
|
17
17
|
SQLServer2017
|
18
18
|
|
19
|
-
ASP.NET
|
19
|
+
ASP.NET Web Forms
|
20
|
+
|
21
|
+
VB.NET
|
20
22
|
|
21
23
|
EntityFramework6.2.0
|
22
24
|
|