62,074
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data.SqlClient;
using System.Linq;
using System.Data.Linq;
using System.IO;
class TestBoxing
{
static void Main()
{
string userTempFolder = Environment.GetEnvironmentVariable("SystemDrive") + @"\YJingLee";
string userMDF = System.IO.Path.Combine(userTempFolder, @"NewCreateDB.mdf");
string connStr = String.Format(@"Data Source=hm;AttachDbFilename={0};User ID=sa;pwd=sa;", userMDF);
DataContext db = new DataContext(connStr);
//string strConn = @"Data Source=hm;Initial Catalog=Test;User ID=sa;pwd=sa";
//DataContext db = new DataContext(strConn);
if (db.DatabaseExists() == true)
{
Console.WriteLine(db.Connection.Database + "数据库已经存在。");
}
else
{
Console.WriteLine(db.Connection.Database + "数据库不存在。");
db.CreateDatabase();
}
Console.ReadLine();
}
}
public class MyDB : DataContext
{
public Table<Passport> PassportTable;
public Table<User> UserTable;
public Table<GroupBase> GroupBaseTable;
public Table<SysLog> SysLogTable;
public Table<Message> t6;
}