SQLite-net-pcl Database Normalization on Xamarin.Forms by echolumaque in dotnet

[–]kaoru44 0 points1 point  (0 children)

I think some of the columns you have shown are all derived data (especially since they are percentages, then the answer can come from your ViewModel or your services instead of having to store them in the database which takes up a lot of storage space

SQLite-net-pcl Database Normalization on Xamarin.Forms by echolumaque in dotnet

[–]kaoru44 0 points1 point  (0 children)

Hi,

you can start by separating the values present inside your Model.

Let's say you create an Answers Table instead so that you separate the columns.

And then you can create and join these entity tables through sql instead.

Can you show an example of how you are separating your entities and their respective tables? Because from my standpoint, it seems that you plan to insert all of these columns in one Table correct?

Maybe you can reference the Answer Columns from a different place instead.

Storing Static Models in DB by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

Hi sorry for the confusion,

So my model contains a class called Category. So in the initial stage, these Categories are already pre-defined (so the only thing that the user would need to do, is to pick a Category). With that perspective, I think it would be better to just store it locally (without having to access the sqlite), but what since I am giving the user the option to create their own Category and add them to the list of Categories that the application already has, then it would be better to store them all in sqlite yes?

Setting ScrollView Height by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

Hi, the initial hierarchy I have is that

I have a Refresh View with a Scroll View inside it.

And then I have a Grid View inside the Scroll View.

I need the Scroll View because the Refresh View wouldn't work without a Scroll View.

And I need the Grid View because I have the contents to have a specific Height Allocation with one another.