开他娘的源，我自己的linqtoAccess

Linq有toSql竟然没有toAccess，对于我这种爱做小项目的人来说这不是坑爹么？？用Access的就不配用Linq么？于是乎利用业余时间搞了个linqtoAccess，开源一下，希望大家多提意见！
编译环境： vs2010

选择Access路径后，点击生成按钮，可以自动生成Access里面所有的表对应的类，还有insert update delete的方法。

用法

 

//new 一个新的总体，会自动把数据取出来，access一般数据没多大，直接都搞出来了。 ydhAcessEntity a = new ydhAcessEntity(); this.dataGridView1.DataSource = a.ta; //先new一个新的ta表的实例， ta nta = new ta(); //新的实例赋值 nta.taa = "nwe"; //用这个方法insert，注意，Submit_y()函数才会真正提交 a.Insert_y(nta); //用linq的方式取得表中对应的实例，直接修改后，提交会自动修改。 ta ota = a.ta[0]; ota.taa = "xiugai"; //用linq的方式取得表中对应的实例，用此方法删除，提交会自动删除。 ta dta = a.ta[1]; a.Delete_y(dta); //提交 a.Submit_y(); 

设计器：

namespace myLinqtoAccess { partial class Form1 { /// <summary> /// 必需的设计器变量。 /// </summary> private System.ComponentModel.IContainer components = null; /// <summary> /// 清理所有正在使用的资源。 /// </summary> /// <param name="disposing">如果应释放托管资源，为 true；否则为 false。</param> protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } #region Windows 窗体设计器生成的代码 /// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.button1 = new System.Windows.Forms.Button(); this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog(); this.label1 = new System.Windows.Forms.Label(); this.button2 = new System.Windows.Forms.Button(); this.saveFileDialog1 = new System.Windows.Forms.SaveFileDialog(); this.label2 = new System.Windows.Forms.Label(); this.textBox1 = new System.Windows.Forms.TextBox(); this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(196, 24); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(75, 23); this.button1.TabIndex = 0; this.button1.Text = "打开"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // openFileDialog1 // this.openFileDialog1.FileOk += new System.ComponentModel.CancelEventHandler(this.openFileDialog1_FileOk); // // label1 // this.label1.Location = new System.Drawing.Point(13, 58); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(258, 55); this.label1.TabIndex = 1; // // button2 // this.button2.Enabled = false; this.button2.Location = new System.Drawing.Point(196, 166); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(75, 23); this.button2.TabIndex = 2; this.button2.Text = "生成"; this.button2.UseVisualStyleBackColor = true; this.button2.Click += new System.EventHandler(this.button2_Click); // // saveFileDialog1 // this.saveFileDialog1.FileName = "LinqToAccess_YDH.cs"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(13, 142); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(149, 12); this.label2.TabIndex = 3; this.label2.Text = "密码(如果没有密码则为空)"; // // textBox1 // this.textBox1.Location = new System.Drawing.Point(15, 168); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(100, 21); this.textBox1.TabIndex = 4; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(292, 211); this.Controls.Add(this.textBox1); this.Controls.Add(this.label2); this.Controls.Add(this.button2); this.Controls.Add(this.label1); this.Controls.Add(this.button1); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.MaximizeBox = false; this.MinimizeBox = false; this.Name = "Form1"; this.ResumeLayout(false); this.PerformLayout(); } #endregion private System.Windows.Forms.Button button1; private System.Windows.Forms.OpenFileDialog openFileDialog1; private System.Windows.Forms.Label label1; private System.Windows.Forms.Button button2; private System.Windows.Forms.SaveFileDialog saveFileDialog1; private System.Windows.Forms.Label label2; private System.Windows.Forms.TextBox textBox1; } }  

源码：

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Fo