Create c# class with a table. Sqlite-net

Question

I have SQLite database in isolated storage in Windows Store App. I use SQLite for Windows Runtime

My class:

[Table("Projects")]
public class Project
{
    [PrimaryKey]
    [Column ("id")]
    public int Id { get; set; }

    [Column("group_id")]
    public int GroupId { get; set; }

    public string Name { get; set; }
}

I get data from web server and put it to local DataBase. When I try to store data to DataBase, I handled exeption

 e.message = table Projects has no column named Name

because DataBase haven't column "Name"

My question is: How to use one class with fields, maping to DataBase Column and simple fields? (I wont not include some fields to DataBase, but I need it in class.)

UPD.

using System.ComponentModel.DataAnnotations.Schema;

[NotMapped]
public string Name { get; set; }

Error The type or namespace name 'NotMappedAttribute' does not exist in the namespace 'System.ComponentModel.DataAnnotations.Schema' (are you missing an assembly reference?)

When I try to add System.ComponentModel.DataAnnotations.dll Error: System.ComponentModel.DataAnnotations.dll could not be added. This component is already automaticaly referenced by the build system.

Which ORM are you using? So form where are the Table and PrimaryKey etc attributes come from? — nemesv
– nemesv, Commented Apr 22, 2013 at 14:41

nemesv · Accepted Answer · 2013-04-22 19:13:03Z

2

It seems you are using the sqlite-net library in this case you need to use the SQLite.IgnoreAttribute

[SQLite.Ignore]
public string Name { get; set; }

edited Apr 22, 2013 at 19:13

answered Apr 22, 2013 at 12:22

nemesv

140k16 gold badges424 silver badges364 bronze badges

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

1 Comment

Andrei Zhukouski Over a year ago

thanks for answer, but I'd try it already. Check updated question.

Collectives™ on Stack Overflow

Create c# class with a table. Sqlite-net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related