Class Objects - Hierachy and Inheritance ( NOT WORKING)
0
I have a (People) or Users objects, of which I am using class inheritance to create the various objects.
However I am getting errors INVALID COLUMN, when I add the object, Users_Accounts which exist in the database with their respective columns below, I get the error
what am I doing wrong ?
ERROR MESSAGE
An unhandled exception occurred while processing the request.
SqlException: Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_PhonePhoneID'.
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
}
public enum Gender
{
male,female
}
and my controller code
var user = HttpContext.User.Identity.Name.ToString();
var DataContext = _context.Users.Include(c => c.Users_Accounts);
return View(await DataContext.SingleOrDefaultAsync(c => c.Email == user && !c.IsSuspended));
asp.net-mvc asp.net-core-2.0
asked Nov 17 '18 at 16:35
Dave Hunse
11
add a comment |
0
I have a (People) or Users objects, of which I am using class inheritance to create the various objects.
However I am getting errors INVALID COLUMN, when I add the object, Users_Accounts which exist in the database with their respective columns below, I get the error
what am I doing wrong ?
ERROR MESSAGE
An unhandled exception occurred while processing the request.
SqlException: Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_PhonePhoneID'.
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
}
public enum Gender
{
male,female
}
and my controller code
var user = HttpContext.User.Identity.Name.ToString();
var DataContext = _context.Users.Include(c => c.Users_Accounts);
return View(await DataContext.SingleOrDefaultAsync(c => c.Email == user && !c.IsSuspended));
asp.net-mvc asp.net-core-2.0
asked Nov 17 '18 at 16:35
Dave Hunse
11
What is the relationship between the two models ? One-to-one ? See docs.microsoft.com/en-us/ef/core/modeling/relationships
– Nan Yu
Nov 19 '18 at 8:03
add a comment |
0
0
0
I have a (People) or Users objects, of which I am using class inheritance to create the various objects.
However I am getting errors INVALID COLUMN, when I add the object, Users_Accounts which exist in the database with their respective columns below, I get the error
what am I doing wrong ?
ERROR MESSAGE
An unhandled exception occurred while processing the request.
SqlException: Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_PhonePhoneID'.
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
}
public enum Gender
{
male,female
}
and my controller code
var user = HttpContext.User.Identity.Name.ToString();
var DataContext = _context.Users.Include(c => c.Users_Accounts);
return View(await DataContext.SingleOrDefaultAsync(c => c.Email == user && !c.IsSuspended));
asp.net-mvc asp.net-core-2.0
asked Nov 17 '18 at 16:35
Dave Hunse
11
I have a (People) or Users objects, of which I am using class inheritance to create the various objects.
However I am getting errors INVALID COLUMN, when I add the object, Users_Accounts which exist in the database with their respective columns below, I get the error
what am I doing wrong ?
ERROR MESSAGE
An unhandled exception occurred while processing the request.
SqlException: Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_AccountsAccountID'.
Invalid column name 'Users_PhonePhoneID'.
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
}
public enum Gender
{
male,female
}
and my controller code
var user = HttpContext.User.Identity.Name.ToString();
var DataContext = _context.Users.Include(c => c.Users_Accounts);
return View(await DataContext.SingleOrDefaultAsync(c => c.Email == user && !c.IsSuspended));
asp.net-mvc asp.net-core-2.0
asp.net-mvc asp.net-core-2.0
asked Nov 17 '18 at 16:35
Dave Hunse
11
asked Nov 17 '18 at 16:35
Dave Hunse
11
asked Nov 17 '18 at 16:35
Dave Hunse
11
asked Nov 17 '18 at 16:35
Dave Hunse
11
asked Nov 17 '18 at 16:35
Dave Hunse
11
11
What is the relationship between the two models ? One-to-one ? See docs.microsoft.com/en-us/ef/core/modeling/relationships
– Nan Yu
Nov 19 '18 at 8:03
add a comment |
What is the relationship between the two models ? One-to-one ? See docs.microsoft.com/en-us/ef/core/modeling/relationships
– Nan Yu
Nov 19 '18 at 8:03
What is the relationship between the two models ? One-to-one ? See docs.microsoft.com/en-us/ef/core/modeling/relationships
– Nan Yu
Nov 19 '18 at 8:03
What is the relationship between the two models ? One-to-one ? See docs.microsoft.com/en-us/ef/core/modeling/relationships
– Nan Yu
Nov 19 '18 at 8:03
add a comment |
1 Answer
1
active
oldest
votes
1
Try this code:
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserAccountID { get; set; }
[ForeignKey(nameof(UserAccountID))]
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public int UserPhoneID { get; set; }
[ForeignKey(nameof(UserPhoneID))]
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserID { get; set; }
[ForeignKey(nameof(UserID ))]
public Users Users { get; set; }
}
public enum Gender
{
male,female
}
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
does not work. I even tried using [ForeignKey("UserID ")]
– Dave Hunse
Nov 18 '18 at 14:45
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53353232%2fclass-objects-hierachy-and-inheritance-not-working%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Try this code:
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserAccountID { get; set; }
[ForeignKey(nameof(UserAccountID))]
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public int UserPhoneID { get; set; }
[ForeignKey(nameof(UserPhoneID))]
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserID { get; set; }
[ForeignKey(nameof(UserID ))]
public Users Users { get; set; }
}
public enum Gender
{
male,female
}
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
does not work. I even tried using [ForeignKey("UserID ")]
– Dave Hunse
Nov 18 '18 at 14:45
add a comment |
1
Try this code:
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserAccountID { get; set; }
[ForeignKey(nameof(UserAccountID))]
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public int UserPhoneID { get; set; }
[ForeignKey(nameof(UserPhoneID))]
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserID { get; set; }
[ForeignKey(nameof(UserID ))]
public Users Users { get; set; }
}
public enum Gender
{
male,female
}
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
does not work. I even tried using [ForeignKey("UserID ")]
– Dave Hunse
Nov 18 '18 at 14:45
add a comment |
1
1
1
Try this code:
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserAccountID { get; set; }
[ForeignKey(nameof(UserAccountID))]
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public int UserPhoneID { get; set; }
[ForeignKey(nameof(UserPhoneID))]
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserID { get; set; }
[ForeignKey(nameof(UserID ))]
public Users Users { get; set; }
}
public enum Gender
{
male,female
}
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
Try this code:
namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserAccountID { get; set; }
[ForeignKey(nameof(UserAccountID))]
public Users_Accounts Users_Accounts { get; set; }
}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public int UserPhoneID { get; set; }
[ForeignKey(nameof(UserPhoneID))]
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserID { get; set; }
[ForeignKey(nameof(UserID ))]
public Users Users { get; set; }
}
public enum Gender
{
male,female
}
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
answered Nov 17 '18 at 17:24
Hamed Naeemaei
39027
39027
does not work. I even tried using [ForeignKey("UserID ")]
– Dave Hunse
Nov 18 '18 at 14:45
add a comment |
does not work. I even tried using [ForeignKey("UserID ")]
– Dave Hunse
Nov 18 '18 at 14:45
does not work. I even tried using [ForeignKey("UserID ")]
– Dave Hunse
Nov 18 '18 at 14:45
does not work. I even tried using [ForeignKey("UserID ")]
– Dave Hunse
Nov 18 '18 at 14:45
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53353232%2fclass-objects-hierachy-and-inheritance-not-working%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What is the relationship between the two models ? One-to-one ? See docs.microsoft.com/en-us/ef/core/modeling/relationships
– Nan Yu
Nov 19 '18 at 8:03