linq,创建数据库,插入数据,newDB.CreateDatabase();newDB.tb2.InsertOnSubmit(stu); newDB.SubmitChanges();
using System.Data.Linq;
using System.Data.Linq.Mapping;
namespace ConsoleApplication1388
{
class Program
{
static void Main(string[] args)
{
string sourceString = "Server=SMOOTHFU;Database=mydb2;Integrated Security=SSPI";
CreateDB newDB = new CreateDB(sourceString);
//创建数据库
newDB.CreateDatabase();
Student stu = new Student
{
id = 10,
name = "ZTT"
};
newDB.tb2.InsertOnSubmit(stu);
newDB.SubmitChanges();
}
}
[Table(Name="SecondDB")]
public class Student
{
[Column(IsPrimaryKey =true,Name="id")]
public int id { get; set; }
[Column(Name="name")]
public string name { get; set; }
}
public class CreateDB:DataContext
{
public Table<Student> tb2;
public CreateDB(string connection):base(connection)
{
}
public CreateDB(System.Data.IDbConnection connection):base(connection)
{
}
}
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步