'ef6 Sqlte3 occur error no such column without administrator path (C:\\ProgramData)
when I run Application, I got the following error
"error occured during loading.. System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SQLite.SQLiteException: SQL logic error no such column: Extent1.is_custom
my sqlite3 file is in C:\ProgramData
here is my SQL syntax for creating table
create table tb_sample
(
id integer
constraint table_name_pk
primary key autoincrement,
name varchar not null,
is_custom integer default 0
);
when I run an Application with the Window's Administration option there is no error.
here is my class
[Table("tb_sample")]
public class TestCaseItem : IComparable<TestCaseItem>
{
[Column("id")]
public int ID { get; set; }
[Column("name")]
public string Name { get; set; }
[Column("is_custom")]
public bool IsCustom { get; set; }
public TestCaseItem()
{
CreateDateTime = DateTime.Now.ToString("yyyyMMdd");
}
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
