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();
}
}
}
C# EF框架增加和查询
于 2022-09-08 12:01:07 首次发布