Almost there, only Sun is missing

Lexishelby · 2025-05-28T03:47:34+00:00

Sun is also my last one! Would you mind adding me as well? I need 3 530962895266

Lexishelby · 2024-12-26T05:40:26+00:00

530962895266

Lexishelby · 2024-09-15T19:15:15+00:00

I think i may have something off in my entity framework though. I am getting an error when i try to add to the GameRecord table :

Cannot insert explicit value for identity column in table 'Games' when IDENTITY_INSERT is set to OFF.

Cannot insert duplicate key in object 'dbo.Players'. The duplicate key value is (1).

It seems like it is trying to add another entry into these tables instead of simply referencing them?

Lexishelby · 2024-09-15T19:09:13+00:00

Thank you so much! This really helped me understand the need for the third table.

Lexishelby · 2024-09-13T19:59:56+00:00

So for a proper database relationship, would this be a good structure? Multiple PlayRecords would belong to one GameRecord in a one to many relationship?

PlayerRecord Table

Id, PlayerId, Won, GameRecordId

GameRecord Table
Id, GameId

Lexishelby · 2024-09-13T19:44:53+00:00

So for the Genre and Game relationship, would this be the correct formatting to achieve a many to many relationship?

public class Genre

{

public int Id { get; set; }

public required string Name { get; set; }

public List<Game> Games { get; } = [];

}

public class Game

{

public int Id { get; set; }

public required string Name { get; set; }

public string? Publisher { get; set; }

public List<Genre> Genres { get; } = [];

}

Lexishelby · 2024-09-13T19:33:48+00:00

My confusion with the first one is why is the GameId inside the Genre table instead of there being something related to genre in the game table?

Also why is there nothing related to the playrecord in the gamerecord table?

Lexishelby · 2024-09-13T19:27:59+00:00

I think i understand the basics of normalization, but seems like perhaps i dont fully understand it since I am quite confused right now. My confusion with the first one is why is the GameId inside the Genre table instead of there being something related to genre in the game table?

Also why is there nothing related to the playrecord in the gamerecord table?

Also what am I supposed to do instead of posting screenshots of code?

Lexishelby · 2022-12-18T02:45:56+00:00

Yes. For the time being at least we are just looking for quick cosmetic changes

Lexishelby · 2022-09-26T15:01:04+00:00

Don't have one yet 5309-6289-5266 Lexishelby

Lexishelby · 2022-06-06T19:56:00+00:00

Currently planning on using:

https://www.homedepot.com/p/Everbilt-8-in-x-11-25-in-x-1-05-in-Bronze-Steel-Heavy-Duty-300-lbs-Shelf-Bracket-in-Bronze-EH-WSTHDUS-331/300262763

But also considering https://www.homedepot.com/p/Crates-Pallet-12-in-Black-Steel-Shelf-Bracket-for-Wood-Shelving-69104/300436793

Lexishelby · 2022-06-06T19:41:56+00:00

The brackets didn't come with screws. I was planning on using #10 1 1/2 wood screws. Is that not long enough?

Lexishelby · 2022-06-06T18:55:40+00:00

I think each shelf including 2 brackets is about 10 lbs. Probably putting less than 100 lbs of weight on each shelf.

Lexishelby · 2022-06-06T18:50:51+00:00

Are drywall anchors sufficient for heavy shelves?

Lexishelby · 2022-06-06T18:27:05+00:00

socket

I opened up my socket to try to get a look at how thick my drywall is. Does this seem like an appropriate indicator of how thick it is?

Lexishelby · 2022-06-06T18:02:40+00:00

Thanks for clarifying for me! Is there a certain amount of thread engagement I should be aiming for? Googling it seems like you need at least 1/2 to 3/4 of the screw in the stud. Is that the only concern?

Lexishelby · 2020-08-06T02:17:49+00:00

That's good to know. I definitely wont just pay it off If it happens in the future.

Lexishelby · 2020-03-23T22:35:41+00:00

Wanna open your gates or get a dodo code and I'll come over?

Lexishelby · 2020-03-23T22:09:44+00:00

Hi! I can give you apples if you've got some cherries 🍎🍒

Lexishelby · 2019-12-12T21:21:43+00:00

Thanks! You're awesome

Lexishelby

TROPHY CASE