[LinqToSql基础知识]
===================================
创建数据库必须注意一点:就是不能创建一个空的数据库,也就是说数据库中必须最少要有一个表
例子如:
System.Data.Linq.DataContext ctx = new DataContext("server=. ;database=testdb; uid=sa; pwd=");
ctx.CreateDatabase();
通过这种方法是不能创建testdb数据库的
正确创建数据库示例如下:
- using System.Data.Linq;
- using System.Data.Linq.Mapping;
- [Table(Name = "test")]
- public class test
- {
- [Column(IsPrimaryKey = true, IsDbGenerated = true)]
- public int ID { get; set; }
- [Column(DbType = "varchar(20)")]
- public string Name { get; set; }
- }
- public partial class testContext : DataContext
- {
- public Table<test> test;
- public testContext(string connection) : base(connection) { }
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- testContext ctx = new testContext("server=.;database=testdb;uid=sa;pwd=");
- ctx.CreateDatabase();
- this.Label1.Text = "恭喜您!成功创建数据库testdb";
- }
- protected void Button2_Click(object sender, EventArgs e)
- {
- testContext ctx = new testContext("server=.;database=testdb;uid=sa;pwd=");
- ctx.DeleteDatabase();
- this.Label2.Text = "恭喜您!成功删除数据库testdb";
- }