- class Program
- {
- static void Main(string[] args)
- {
- //1.插入******BlogEntities为数据库的对象,按需更改********
- using (BlogEntities dbContext = new BlogEntities())
- {
- //插入一条*********T_Article为表的对象,按需更改*********
- T_Article article = new T_Article()
- {
- Title = "标题1",
- Content = "内容1",
- PublishTime = DateTime.Now
- };
- dbContext.T_Article.Add(article);
-
- //插入多条
- for (int i = 0; i < 10; i++)
- {
- T_Article article = new T_Article()
- {
- Title = "标题"+i,
- Content = "内容"+i,
- PublishTime = DateTime.Now
- };
- dbContext.T_Article.Add(article);
- }
- dbContext.SaveChanges();
- }
- //2.查询
- //2.1查询所有
- using (BlogEntities dbContext = new BlogEntities())
- {
- foreach (var item in dbContext.T_Article)
- {
- Console.WriteLine("Id=" + item.ArticleId + ";Title=" + item.Title + ";Content=" + item.Content);
- }
- }
- //2.2条件查询
- using (BlogEntities dbContext = new BlogEntities())
- {
- var result = dbContext.T_Article.Where(a => a.Title == "标题1");
- foreach (var item in result)
- {
- Console.WriteLine("Id=" + item.ArticleId + ";Title=" + item.Title + ";Content=" + item.Content);
- }
- }
- Console.ReadKey();
- }
- }
- }