C基于SQLiteHelper类似SqlHelper类实现存取Sqlite数据库的方法.docVIP

C#基于SQLiteHelper类似SqlHelper类实现存取Sqlite数据库的方法 这篇文章主要介绍了C#基于SQLiteHelper类似SqlHelper类实现存取Sqlite数据库的方法,涉及C#操作SQLite数据库的相关技巧,需要的朋友可以参考下 本文实例讲述了C#基于SQLiteHelper类似SqlHelper类实现存取Sqlite数据库的方法。分享给大家供大家参考。具体如下： 这个类不是我实现的，英文原文地址为eggheadcafe/articlesasp，这里修改了原文中分析sql语句参数的方法，将方法名修改为AttachParameters，将其修饰符修改为private，并直接传递command到这个方法，直接绑定参数到comand。修改后的代码如下 using System;using System.Data;using System.Text.RegularExpressions;using System.Xml;using System.IO;using System.Collections;using System.Data.SQLite;namespace DBUtility.SQLite{ /// summary /// SQLiteHelper is a utility class similar to SQLHelper in MS /// Data Access Application Block and follows similar pattern. /// /summary public class SQLiteHelper { /// summary /// Creates a new see cref=SQLiteHelper/ instance. The ctor is marked private since all members are static. /// /summary private SQLiteHelper() { } /// summary /// Creates the command. /// /summary /// param name=connectionConnection./param /// param name=commandTextCommand text./param /// param name=commandParametersCommand parameters./param /// returnsSQLite Command/returns public static SQLiteCommand CreateCommand(SQLiteConnection connection, string commandText, params SQLiteParameter[] commandParameters) { SQLiteCommand cmd = new SQLiteCommand(commandText, connection); if (commandParameters.Length 0) { foreach (SQLiteParameter parm in commandParameters) cmd.Parameters.Add(parm); } return cmd; } /// summary /// Creates the command. /// /summary /// param name=connectionStringConnection string./param /// param name=commandTextCommand text./param /// param name=commandParametersCommand parameters./param /// returnsSQLite Command/returns public static SQLiteCommand CreateCommand(string connectionString, string commandText, params SQLiteParameter[] commandParameters) { SQLiteConnection cn = new SQLiteConnection(connectionString); SQLiteCommand cmd = new SQLiteCommand(commandText, cn); if (commandParameters.L