Xamarin: Binding a Database instance to a Database Entry

Question

Xamarin: Binding a Database instance to a Database Entry

Joseph H. Choi 1

I am working off of the "Notes" Xamarin tutorial. I would like to create a list saved within a entry, like so:

The issue is that the list is persistent through all Order entries. What I am trying to do is have each Order entry have its own unique modifiable list. How do I bind a new list to a new Order(Note) entry?

codeshare for NoteEntryPage.xaml.cs

loQ36D

JarvanZhang 23,971

How do I bind a new list to a new Order(Note) entry

You could add some parameters to save the text of these entries separately as below.

public class Note
{
    [PrimaryKey, AutoIncrement]
    public int ID { get; set; }
    ...
    public string Order { get; set; }
    public string Name { get; set; }
    public string Brand { get; set; }
    public int Quanity { get; set; }
    public Color ContentColor { get; set; }
}

Joseph H. Choi 1 Reputation point

2022-02-15T04:55:42.38+00:00

Can that work with a database object? For example, right now I am using a Product.cs class with a ProductDatabase.cs database. So would I then ProductDatabase type parameter?
JarvanZhang 23,971 Reputation points

2022-02-15T05:23:35.543+00:00

Yes. You could refer to this sample: https://learn.microsoft.com/en-us/samples/xamarin/xamarin-forms-samples/getstarted-notes-database/
Joseph H. Choi 1 Reputation point

2022-02-17T00:58:15.44+00:00

Okay I don't think you understand exactly what I wish to do. For ease of comprehension, I will use the example from the link that you posted.

In that example, we have two page views of interest: The NotesPage.xaml, and NoteEntryPage.xaml. Everything in the NotesPage.xaml view is fine. The issue arises in that I wish to have a separate database for each "note" that is viewed in the NoteEntryPage.xaml view.

In other words, each "note" entry within the Note Database has its own "item" database, viewable from the NoteEntryPage.xaml view, not NotesPage.xaml view like it is in the example.

For example, I create a "note 1", and it will have its own database of "items" within it. Then I could create a "note 2" with its own database of "items". An app with functionality very similar to what I am looking for would be the Samsung Notes app, where I can create an individual note, and each note can store its own unique list of text.

I attempted to add a database object to the Note class, but all that happens is that it is not recognized, despite the existence of the class and its associated objects.
JarvanZhang 23,971 Reputation points

2022-02-17T06:40:50.463+00:00

In other words, each "note" entry within the Note Database has its own "item" database

If you want to create multi tables and database files, then pass the data to each entry. You need to connect to each database and use the corresponding table.

Your answer

JarvanZhang 23,971 Reputation points

2022-02-15T02:20:35.473+00:00

How do I bind a new list to a new Order(Note) entry

You could add some parameters to save the text of these entries separately as below.

public class Note { [PrimaryKey, AutoIncrement] public int ID { get; set; } ... public string Order { get; set; } public string Name { get; set; } public string Brand { get; set; } public int Quanity { get; set; } public Color ContentColor { get; set; } }
Joseph H. Choi 1 Reputation point

2022-02-15T04:55:42.38+00:00

Can that work with a database object? For example, right now I am using a Product.cs class with a ProductDatabase.cs database. So would I then ProductDatabase type parameter?
JarvanZhang 23,971 Reputation points

2022-02-15T05:23:35.543+00:00

Yes. You could refer to this sample: https://learn.microsoft.com/en-us/samples/xamarin/xamarin-forms-samples/getstarted-notes-database/
Joseph H. Choi 1 Reputation point

2022-02-17T00:58:15.44+00:00

Okay I don't think you understand exactly what I wish to do. For ease of comprehension, I will use the example from the link that you posted.

In that example, we have two page views of interest: The NotesPage.xaml, and NoteEntryPage.xaml. Everything in the NotesPage.xaml view is fine. The issue arises in that I wish to have a separate database for each "note" that is viewed in the NoteEntryPage.xaml view.

In other words, each "note" entry within the Note Database has its own "item" database, viewable from the NoteEntryPage.xaml view, not NotesPage.xaml view like it is in the example.

For example, I create a "note 1", and it will have its own database of "items" within it. Then I could create a "note 2" with its own database of "items". An app with functionality very similar to what I am looking for would be the Samsung Notes app, where I can create an individual note, and each note can store its own unique list of text.

I attempted to add a database object to the Note class, but all that happens is that it is not recognized, despite the existence of the class and its associated objects.
JarvanZhang 23,971 Reputation points

2022-02-17T06:40:50.463+00:00

In other words, each "note" entry within the Note Database has its own "item" database

If you want to create multi tables and database files, then pass the data to each entry. You need to connect to each database and use the corresponding table.

Share via

Xamarin: Binding a Database instance to a Database Entry

Your answer