LINQ用于数据库访问的基本方法示例

最新推荐文章于 2023-12-23 13:22:24 发布

weixin_30339457

最新推荐文章于 2023-12-23 13:22:24 发布

阅读量371

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/tianjinquan/archive/2010/12/24/1916335.html

该博客为转载内容，转载自https://www.cnblogs.com/tianjinquan/archive/2010/12/24/1916335.html ，涉及数据库相关知识。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Linq;

namespace LINQ_TO_SQL
{
[Table(Name = "t_guestinfo")]
public class GuestInfo
{
[Column(IsPrimaryKey = true, Name = "ab_id")]

private string id;
public string ID
{
get { return this.id; }
set { this.id = value; }
}

private string name;

public string Name
{
get { return this.name; }
set { this.name = value; }
}
}

class Program
{
static void Main(string[] args)
{
DataContext db = new DataContext("c:\\DbAddressBook.mdf");
Table<GuestInfo> guestinfo = db.GetTable<GuestInfo>();

IQueryable<GuestInfo> query =
from g in guestinfo
where g.Name == "xiao"
select g;

foreach (GuestInfo guest in query)
{
Console.WriteLine("ID={0},Name ={1}", guest.ID, guest.Name);
}
}
}
}

转载于:https://www.cnblogs.com/tianjinquan/archive/2010/12/24/1916335.html