Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
Creating Database First Using EF SQL Failing
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
David Watson
7y
238
1
Reply
GO
CREATE
TABLE
[dbo].[StreetType] (
[StreetTypeID]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([StreetTypeID]
ASC
),
[StreetType] NVARCHAR (150)
NOT
NULL
);
GO
CREATE
TABLE
[dbo].[Address] (
[AddressID]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([AddressID]
ASC
),
[StreetNumber] NVARCHAR (9)
NULL
,
[StreetName] NVARCHAR (80)
NULL
,
[StreetTypeID]
INT
NULL
,
[SuburbID]
INT
NULL
,
CONSTRAINT
[FK_dbo.Address_dbo.StreetType_StreetTypeID]
FOREIGN
KEY
([StreetTypeID])
REFERENCES
[dbo].[StreetType] ([StreetTypeID]),
CONSTRAINT
[FK_dbo.Address_dbo.Suburb_SuburbID]
FOREIGN
KEY
([SuburbID])
REFERENCES
[dbo].[Suburb] ([SuburbID])
);
GO
CREATE
TABLE
[dbo].[ConnectType] (
[ConnectTypeId]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([ConnectTypeId]
ASC
),
[ConnectType] NVARCHAR (40)
NOT
NULL
);
GO
CREATE
TABLE
[dbo].[Contact] (
[ContactID]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([ContactID]
ASC
),
[ShentonAccCode] NVARCHAR (12)
NULL
,
[ContactTypeID]
INT
NOT
NULL
,
[ContactName] NVARCHAR (150)
NOT
NULL
,
[AddressID]
INT
NULL
,
[AnnDate]
DATE
NULL
,
CONSTRAINT
[FK_dboContact_dboAddress_AddressID]
FOREIGN
KEY
([AddressID])
REFERENCES
[dbo].[Address] ([AddressID]),
CONSTRAINT
[FK_dboContact_dboContactType_ContactTypeID]
FOREIGN
KEY
([ContactTypeID])
REFERENCES
[dbo].[ContactType] ([ContactTypeID])
);
GO
CREATE
TABLE
[dbo].[ContactPosition] (
[ContactPositionID]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([ContactPositionID]
ASC
),
[Position] NVARCHAR (90)
NOT
NULL
);
GO
CREATE
TABLE
[dbo].[ContactStaff] (
[ContactStaffID]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([ContactStaffID]
ASC
),
[ContactID]
INT
NOT
NULL
,
[
Name
] NVARCHAR (150)
NOT
NULL
,
[ContactPositionID]
INT
NULL
CONSTRAINT
[FK_dbo.ContactStaff_dbo.Contact_ContactID]
FOREIGN
KEY
([ContactID])
REFERENCES
[dbo].[Contact] ([ContactID]),
CONSTRAINT
[FK_dbo.ContactStaff_dbo.ContactPosition_PositionID]
FOREIGN
KEY
([ContactPositionID])
REFERENCES
[dbo].[ContactPosition] ([ContactPositionID])
);
GO
CREATE
TABLE
[dbo].[ContactStaffDetails] (
[ContactStaffDetailsId]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([ContactStaffDetailsId]
ASC
),
[ContactID]
INT
NOT
NULL
,
[ContactStaffID]
INT
NOT
NULL
,
[ContactTypeID]
INT
NOT
NULL
,
[ContactDetail] NVARCHAR (200)
NULL
,
CONSTRAINT
[FK_dbo.ContactStaffDetails_dbo.Contact_ContactID]
FOREIGN
KEY
([ContactID])
REFERENCES
[dbo].[Contact] ([ContactID]),
CONSTRAINT
[FK_dbo.ContactStaffDetails_dbo.ContactStaff_ContactStaffID]
FOREIGN
KEY
([ContactStaffID])
REFERENCES
[dbo].[ContactStaff] ([ContactStaffID]),
CONSTRAINT
[FK_dbo.ContactStaffDetails_dbo.ContactType_ContactTypeID]
FOREIGN
KEY
([ContactTypeID])
REFERENCES
[dbo].[ContactType] ([ContactTypeID])
);
GO
CREATE
TABLE
[dbo].[ContactType] (
[ContactTypeID]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([ContactTypeID]
ASC
),
[ContactType] NVARCHAR (50)
NOT
NULL
);
GO
CREATE
TABLE
[dbo].[Suburb] (
[SuburbID]
INT
IDENTITY (1, 1)
NOT
NULL
PRIMARY
KEY
CLUSTERED ([SuburbID]
ASC
),
[Suburb] NVARCHAR (90)
NOT
NULL
,
[State] NVARCHAR (8)
NOT
NULL
,
[PostCode] NVARCHAR (6)
NOT
NULL
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_Address_SuburbID]
ON
[dbo].[Address]([SuburbID]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_Contact_AnnDate]
ON
[dbo].[Contact]([AnnDate]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_Contact_ContactName]
ON
[dbo].[Contact]([ContactName]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_ContactTypeID]
ON
[dbo].[Contact]([ContactTypeID]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_ContactPosition_Position]
ON
[dbo].[ContactPosition]([Position]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_ContactStaffDetails_Contact]
ON
[dbo].[ContactStaffDetails]([ContactID]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_ContactStaffDetails_ContactStaff]
ON
[dbo].[ContactStaffDetails]([ContactStaffID]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_Suburb_PostCode]
ON
[dbo].[Suburb]([PostCode]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_Suburb_State]
ON
[dbo].[Suburb]([State]
ASC
);
GO
CREATE
NONCLUSTERED
INDEX
[IX_Suburb_Suburb]
ON
[dbo].[Suburb]([Suburb]
ASC
);
I am only very new to this type of development. I have been working through training on ASP.NET and feel semi confident to start on my first mini project. Yesterday I made a simple example with staff and vehicles and managed to get this completed and working how I thought it should. Feeling a little bolder I decided to set up a slightly more complex model this morning to see how it works. So I created SQL statements and then checked it all looked correct. Click build in Visual Studio and it threw a few errors. No stress went in and corrected all the errors. Deleted the created data base and reran to build again...No errors, build says its fine...but no database visible. I know I have done something silly but I don't even know what to look for.
In case it is something in my SQL, which I sincerely doubt:
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
retrieve values from coumn name
Need to have records vertically