Using Fluent Migrator project you write the following class...
[Migration(201101011411)]
public class Version_002 : FluentMigrator.Migration
{
public override void Up()
{
Create.Column("ColumnName").OnTable("TableName").AsInt32().Nullable();
}
public override void Down()
{
Delete.Column("ColumnName").FromTable("TableName");
}
}
-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of Madhan Kumar
Sent: 22 August 2011 13:27
To: [email protected]
Subject: [sqlite] how to Add a Table in the existing Sqlite database at client
machine
I,
I am using C# windows application(.Net2010) with sqlite,
Can you pls let me know, how to add or modify a new column/ table in
the existing Sqlite database that is in my client desktop machine.
I want the existing database to have its data(not disturbed), and only add a
new table/column.
Is there any way something like bat file - to execute and update the
database file in client machine.
or any other way to execute the scripts( like oracle updation of script)
Waiting for your reply.
Thanks
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
