SQLite.Net, C# equivalent for SQLite bit datatype

Question

I declare following class in c#

[Table("Employee")]
public class Employee
{
    [PrimaryKey,AutoIncrement]
    public int EmployeeId { get; set; } 
    public DateTime DateOfJoining { get; set; }
    public string Address{ get; set; }
}

and i invoke this method to create equivalent table in my SQLite database

public async Task CreateTable()
{
   SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
   await conn.CreateTableAsync<Employee>();
}

So it creates a table in SQLite as follows

[EmployeeId] int,
[DateOfJoining] [datetime],
[CallType] [varchar]

I wanted To create a a column, which is bit

[IsActive] [bit]

For this I tried

public bool IsActive { get; set; }

and

public Boolean IsActive { get; set; }

Both these properties result in a column which is an integer

[IsActive] integer

So how should I declare my IsActive property to get a column with bit as datatype.

I have one more question, If i declare property and specify it as not null

[NotNull]
public bool Address{ get; set; }

Then it gives me an error when I invoke CreateTable() saying, "No default value specified for Not Null attribute".

I tried to initialise this property in constructor, but it didnt work.

How do I go about these issues? Please Help

CodeNoob · Accepted Answer · 2015-01-30 07:36:16Z

2

As far I see in SQLite Docs there is no bit datatype for SQLite

and in SQLite.Net all kind of byte/boolean/ints get mapped to integer: see this line

for the NotNull Error, let me guess:

You have already some entries in your Table
You now add a new Column with NotNull-Attribute
SQLite tries to alter the tablet and it crashes, because multiple entries where the new column has now null values

I think this is the only situation where to have to alter table in this order:

Add Column without NotNull
Add some column values
only once all table entries has the value for this Column --> now you can add the NotNull Attribute

If your Table is empty then the NotNull Parameter would work right from the start.

Edit easier Solution:

Add Column without NotNull

ALTER TABLE Employee ADD COLUMN IsActive integer default 0;

now you can add the NotNull Attribute and call CreateTable again

[NotNull]
public bool Address{ get; set; }

await conn.CreateTableAsync<Employee>();

edited Jan 30, 2015 at 7:36

answered Jan 29, 2015 at 10:45

CodeNoob

9848 silver badges8 bronze badges

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

6 Comments

Gk_999 Over a year ago

So the finl answer is "No, thats not possible". Hats off to your research on this. And +1 for the explaination about not null. Thank you.

Gk_999 Over a year ago

With reference to your last point , How can i add NotNull Attribute after I fill values in all columns??? In short, how will I add NotNull attribute to a property, programatically?

CodeNoob Over a year ago

So you already added the column and filled the values? well then it is quite easy you could just add the NotNull Attribute to your Column and call CreateTableAsync again, this time it should work without an error

Gk_999 Over a year ago

But how to add NotNull attribute programatically to an already existing property??? Something like "IsActive .Attributes.Add('NotNull')"??

Gk_999 Over a year ago

Or you want me to have another similar class with NotNull attribute set to IsActive property, & call the CreateTable() method for this new class??

|

Collectives™ on Stack Overflow

SQLite.Net, C# equivalent for SQLite bit datatype

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related