1.建一个类Article
View Code
1 using System.Data.Linq.Mapping; 2 3 4 5 [Table(Name = "Article")] 6 public class Article 7 { 8 [Column(IsPrimaryKey=true)] 9 public int id10 {11 get;12 set;13 }14 [Column(Name = "containt")]15 public string containt16 {17 get;18 set;19 }20 [Column]21 public string name22 {23 get;24 set;25 }
2 .建一个强类型的强类型DataContext
using System.Data.Linq;public partial class SomeMehod:DataContext {public Table<Article> artic;public SomeMehod(IDbConnection connection) : base(connection) { }public SomeMehod(string connection) : base(connection) { } }
3.开始用DataContext 连接数据库创建数据库
SomeMehod sm = new SomeMehod(@"server=LP-PC\SQLEXPRESSN;database=NewDB;uid=sa;pwd=sa");//创建一个名字叫NewDB的数据库if (sm.DatabaseExists())//判断NewDB是不是存在如果有就删除 { sm.DeleteDatabase(); } sm.CreateDatabase();//创建NewDB
看一下Linq to Sql是怎么操作的:
CREATE DATABASE [NewDB] .Net SqlClient Data Provider: 已将数据库上下文更改为 'NewDB'。。SET ARITHABORT ONCREATE TABLE [Article]([id] Int NOT NULL, [containt] NVarChar(4000), [name] NVarChar(4000), CONSTRAINT [PK_Article] PRIMARY KEY ([id]) )
写的不好,呵呵。
时间: 2024-07-31 17:32:13