linq简单操作

static void Main(string[] args)
{
Linq_DBDataCont.Linq_DBDataContext ctx = new Linq_DBDataCont.Linq_DBDataContext();
Linq_DBDataEnts.users us = new Linq_DBDataEnts.users();
us = ctx.users.FirstOrDefault(a => a.uType == "1");
if (us != null)
{
Console.WriteLine(us.uName);
}
else
{
Console.WriteLine("-----null------");
}
Console.Read();
}

 

 

//SELECT table 直接查询
static void Main(string[] args)
{
Linq_DBDataCont.Linq_DBDataContext ctx = new Linq_DBDataCont.Linq_DBDataContext();
var q = from x in ctx.users
where x.uType == "1"
select new { x.uName, x.uPwd };
if (q.Count() != 0)
{
foreach (var item in q)
{
Console.WriteLine(item);
Console.WriteLine(item.uName);
Console.WriteLine(item.uPwd);
Console.WriteLine("---------------");
}
Console.Read();
}
else
{
Console.WriteLine("--------null-------");
Console.Read();
}

}