ZenORM C# Framework

gistfile1.cs

config = ZenOrmConfig.Instance;

config.DataStore = DataStoreType.MySQL;
config.DataStoreConfig = new ZenORM.Config.MySqlConfig();
config.Debug = true;

Video video = new Video { 
	Director = "Steven",
	NumberOfCast = 30,
	Title = "ET",
	Id = 848//This will be auto assigned by database when not in debug mode
};


video.Init();
video.Save();

var newVideo = Video.Find(848).FirstOrDefault();

video.Title = "Indiana Jones";
video.Save();

video.Delete();

INSERT INTO Video (Director,Title,NumberOfCast,Id) VALUES ('Steven','ET',30,848);
SELECT * FROM Video WHERE Id=848;
UPDATE Video SET Director='Steven', Title='Indiana Jones', NumberOfCast=30 WHERE Id=848;
DELETE FROM Video WHERE Id=848;