How can I use SQLite to create an index with a create table command?

Question

I am using this code to create a table:

db2.CreateTable<Phrase>();

Here's the Phrase class:

public class Phrase : IPhrase
{
    [PrimaryKey, NotNull]
    public string PhraseId { get; set; }
    public int PhraseNum { get; set; }
    public int CategoryId { get; set; }
    public string English { get; set; }
    public string Romaji { get; set; }
}

When I hover over the CreateTable it gives a message saying that it creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type.

Does anyone know how I could for example create an index on the PhraseNum?

SushiHangover · Accepted Answer · 2018-09-01 07:12:47Z

1

For a single property-based index add an IndexedAttribute:

public class Package
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    [Indexed]
    public string Name { get; set; }
    ~~~~

For a multiple field index, use the Name and Order parameters within the IndexedAttribute:

public class Package
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    [Indexed(Name = "SecondaryIndex", Order = 1)]
    public string Name { get; set; }
    [Indexed(Name = "SecondaryIndex", Order = 2)]
    public string PackageName { get; set; }
    ~~~

answered Sep 1, 2018 at 7:12

SushiHangover

74.3k11 gold badges113 silver badges175 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mate · Accepted Answer · 2018-09-01 07:08:59Z

1

Try

  [Indexed]
  public int PhraseNum { get; set; }

answered Sep 1, 2018 at 7:08

Mate

5,3272 gold badges36 silver badges40 bronze badges

Collectives™ on Stack Overflow

How can I use SQLite to create an index with a create table command?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related