先来段起始源码:
需求是: 使用SQLServer数据库,对表User进行Insert和GetUser两个操作
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
SqlserverUser sql = new SqlserverUser();
sql.Insert(new User() { ID = 1, Name = "张三" });
sql.GetUser(1);
Console.ReadKey();
}
}
public class User
{
public int ID { get; set; }
public string Name { get; set; }
}
public class SqlserverUser
{
public void Insert(User user)
{
Console.WriteLine("SQL Server给User表插入一条记录");
}
public User GetUser(int id)
{
Console.WriteLine("SQL Server根据ID得到User表一条记录");
return null;
}
}
}