public void Main(string[] args)
{
using (var db = new BloggingContext())
{
db.Blogs.Add(new Blog { Url = "http://blogs.msdn.com/adonet" });
var count = db.SaveChanges();
Console.WriteLine("{0} records saved to database", count);
Console.WriteLine();
Console.WriteLine("All blogs in database:");
foreach (var blog in db.Blogs)
{
Console.WriteLine(" - {0}", blog.Url);
}
}
}
public void Main(string[] args)
{
using (var db = new BloggingContext())
{
db.Blogs.Add(new Blog {
Url = "http://blogs.msdn.com/adonet"
});
var count = db.SaveChanges();
Console.WriteLine("{0} records saved to database", count);
Console.WriteLine();
Console.WriteLine("All blogs in database:");
foreach (var blog in db.Blogs)
{
Console.WriteLine(" - {0}", blog.Url);
}
}
}
static void Main(string[] args)
{
using (var db = new BloggingContext())
{
if (db.Database.EnsureDeleted() && db.Database.EnsureCreated())
{
DbUtilis.CreateSqliteDb();
db.SaveChanges();
}
}
using (var db = new BloggingContext())
{
var query = db.Blogs;
var sql = "";
try
{
var blogs = db.Query(
query,
new EFModelInfoProvider(db),
new SqliteObjectFactory(),
out sql);
var json = JsonConvert.SerializeObject(blogs, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore,
Formatting = Formatting.Indented
});
Console.WriteLine("Result:");
Console.WriteLine(json);
}
finally
{
Console.WriteLine("Sql:");
Console.WriteLine(sql);
}
}
}
