public void AddBlog(BlogClass _blogs)
{
using (var db = new LocalBlogContext(ConnectionString))
{
db.Blogs.InsertOnSubmit(_blogs);
db.SubmitChanges();
}
}
public IList<BlogClass> GetBlogs()
{
List<BlogClass> blogs = new List<BlogClass>();
using (var db = new LocalBlogContext(ConnectionString))
{
var query = from e in db.Blogs
select e;
blogs = query.ToList();
}
return blogs;
}
// Constructor
public MainPage()
{
InitializeComponent();
using (var db = new LocalBlogContext(ConnectionString))
{
if (!db.DatabaseExists())
db.CreateDatabase();
LoadData();
}
}
