C#•2y ago

Am I doing this correctly? (Foreign Keys & Such, Entity Framework & SQL Server)

I'm trying to figure out how to store objects within objects in the database, that can only be accessed directly or through the UserModel... Kinda like having a sub-folder for organization sake so the usermodel doesn't have 30 columns in it.

I only understand sql on a basic beginner level (one table for one thing, through entity framework only) and asking chatgpt has gotten me this far and i'm not srue if im even doing it right.

The Fog from Human Resources•1/22/24, 8:40 AM

"meow" and "rawr".

MetalkonOP•1/22/24, 8:41 AM

random words influenced by my cat on my desk lol

The Fog from Human Resources•1/22/24, 8:41 AM

You could Also add it as a JSON string into the db

MetalkonOP•1/22/24, 8:41 AM

The Fog from Human Resources•1/22/24, 8:41 AM

I think you can serialize whole objects in vanilla C#

The Fog from Human Resources•1/22/24, 8:42 AM

What database is that

MetalkonOP•1/22/24, 8:42 AM

sql server

The Fog from Human Resources•1/22/24, 8:42 AM

The Fog from Human Resources•1/22/24, 8:43 AM

Honestly I don't think you can easily store sub objects without creating all the values

The Fog from Human Resources•1/22/24, 8:43 AM

My approach for this would be to have the basic things and for things like object extensions I'll serialize them into a JSON object and store them in some additional attribute

The Fog from Human Resources•1/22/24, 8:46 AM

Also I'd say you should use the UNIX timestamp instead of ISO datetime, just preference tho since it's easier to perform math on it

MetalkonOP•1/22/24, 9:08 AM

is unix time generally the way to go in most apps compared to utc?

MMetalkon is unix time generally the way to go in most apps compared to utc?

The Fog from Human Resources•1/22/24, 9:16 AM

the thing is that UNIX timestamp is the exact amount of seconds since 1970 (i think) so you can do very precise time measures

The Fog from Human Resources•1/22/24, 9:17 AM

and also doing things like subscriptions you can just have your subscription age in seconds and then compare if the current timestamp > (subscriptionStart + subscriptionAge)
(this is just an example of the things you can do with it but its very useful to work with the UNIX format instead)

The Fog from Human Resources•1/22/24, 9:20 AM

https://tenor.com/view/cat-swimming-poopsie-silly-gif-14546589990767279660

Tenor

MetalkonOP•1/22/24, 9:44 AM

Btw I cannot modify the refresh token string through the usermodel like this api in the original code.

The Fog from Human Resources•1/22/24, 10:06 AM

i usually use stuff like MySQL and SQLite

The Fog from Human Resources•1/22/24, 10:06 AM

also i dont think you need to tell the async Task what to return

The Fog from Human Resources•1/22/24, 10:06 AM

i usually declare my functions as IActionResult and it works fine

The Fog from Human Resources•1/22/24, 10:07 AM

like this

TThe Fog from Human Resources like this ```cs [HttpGet("someResource")] public async IActionResult(string som...

Angius•1/22/24, 4:26 PM

This will work only because here is useless as you're not awaiting anything

Angius•1/22/24, 4:26 PM

Async methods have to return a task

Angius•1/22/24, 4:27 PM

As for your initial question... it's not how I would've done it, but it should be fine

TThe Fog from Human Resources My approach for this would be to have the basic things and for things like objec...

MetalkonOP•1/23/24, 7:17 AM

I do have some worries about using a json. While im using a test project here in this help thread (for learning purposes and testing how it works), my intention in the real project im working on is to save user game data, which includes player inventories which consist of lists of item objects and i'm worried about database performance, api performance of converting jsons every http request, or various string limits. These strings could be 4-5 digits worth of chars so idk if a json string is enough to handle it.

I could probably impose inventory size limits (ex: 99 items) but the string could still be thousands of chars long.

MetalkonOP•1/23/24, 7:17 AM

Was thinking maybe separate database tables would help with this.

MMetalkon I do have some worries about using a json. While im using a test project here in...

The Fog from Human Resources•1/23/24, 7:23 AM

SQL should have types like TEXT and LONGTEXT, which can store 65.5k characters, or In the case of LONGTEXT it can store up to 4GB

The Fog from Human Resources•1/23/24, 7:24 AM

You could Also use a blob but I'm not sure if that's the kinda approach you'd want

MetalkonOP•1/23/24, 7:24 AM

no clue what a blob is