using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
var context = new TestEntities();
var users = from e in context.users select e;
foreach (var u in users)
{
Console.WriteLine(u.id);
Console.WriteLine(u.name);
Console.WriteLine("-------------");
}
Insert();
Update();
Delete();
Console.Read();
}
/// <summary>
/// 查询
/// </summary>
static void Query()
{
var context = new TestEntities();
var users = from e in context.users select e;
foreach (var u in users)
{
Console.WriteLine(u.name);
Console.WriteLine(u.pass);
Console.WriteLine("-------------");
}
Console.WriteLine("=====================");
}
/// <summary>
/// 插入
/// </summary>
static void Insert()
{
var context = new TestEntities();
users user = new users();
user.name = "test002";
user.pass = "test123";
context.users.Add(user);
context.SaveChanges();
}
/// <summary>
/// 更新
/// </summary>
static void Update()
{
var context = new TestEntities();
var user = (from e in context.users select e).First();
user.pass = "123";
context.SaveChanges();
}
/// <summary>
/// 删除
/// </summary>
static void Delete()
{
TestEntities context = new TestEntities();
var user = (from e in context.users where e.pass.Equals("test002") select e).First();
if (user != null)
{
context.users.Remove(user);
context.SaveChanges();
}
}
}
}
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
var context = new TestEntities();
var users = from e in context.users select e;
foreach (var u in users)
{
Console.WriteLine(u.id);
Console.WriteLine(u.name);
Console.WriteLine("-------------");
}
Insert();
Update();
Delete();
Console.Read();
}
/// <summary>
/// 查询
/// </summary>
static void Query()
{
var context = new TestEntities();
var users = from e in context.users select e;
foreach (var u in users)
{
Console.WriteLine(u.name);
Console.WriteLine(u.pass);
Console.WriteLine("-------------");
}
Console.WriteLine("=====================");
}
/// <summary>
/// 插入
/// </summary>
static void Insert()
{
var context = new TestEntities();
users user = new users();
user.name = "test002";
user.pass = "test123";
context.users.Add(user);
context.SaveChanges();
}
/// <summary>
/// 更新
/// </summary>
static void Update()
{
var context = new TestEntities();
var user = (from e in context.users select e).First();
user.pass = "123";
context.SaveChanges();
}
/// <summary>
/// 删除
/// </summary>
static void Delete()
{
TestEntities context = new TestEntities();
var user = (from e in context.users where e.pass.Equals("test002") select e).First();
if (user != null)
{
context.users.Remove(user);
context.SaveChanges();
}
}
}
}