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

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

主要介绍了C#基于SQLiteHelper类似SqlHelper类实现存取Sqlite数据库的方法,涉及C#操作SQLite数据库的相关技巧,需要的朋友可以参考下

本文实例讲述了C#基于SQLiteHelper类似SqlHelper类实现存取Sqlite数据库的方法。分享给大家供大家参考。具体如下：

这个类不是我实现的，英文原文地址为http://www.eggheadcafe.com/articles/20050315.asp，这里修改了原文中分析sql语句参数的方法，将方法名修改为

AttachParameters，将其修饰符修改为private，并直接传递command到这个方法，直接绑定参数到comand。修改后的代码如下

using System;

using System.Data;

using System.Text.RegularExpressions;

/// <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()

/// <param name="commandText">Command text.</param>

/// <param name="commandParameters">Command parameters.</param>

/// <returns>SQLite 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);

/// <param name="connectionString">Connection string.</param>

/// <param name="commandText">Command text.</param>

/// <param name="commandParameters">Command parameters.</param>

/// <returns>SQLite 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.Length > 0)

{

/// Creates the parameter.

/// </summary>

/// <param name="parameterName">Name of the parameter.</param>

/// <param name="parameterType">Parameter type.</param>

/// <param name="parameterValue">Parameter value.</param>

/// <returns>SQLiteParameter</returns>

public static SQLiteParameter CreateParameter(string parameterName, System.Data.DbType parameterType, object parameterValue)

{

SQLiteParameter parameter = new SQLiteParameter();

parameter.DbType = parameterType;

/// </summary>

/// <param name="connectionString">SQLite Connection string</param>

/// <param name="commandText">SQL Statement with embedded "@param" style parameter names</param>

/// <param name="paramList">object[] array of parameter values</param>

/// <returns></returns>

public static DataSet ExecuteDataSet(string connectionString, string commandText, object[] paramList)

{

SQLiteConnection cn = new SQLiteConnection(connectionString);

SQLiteCommand cmd = cn.CreateCommand();

cmd.CommandText = commandText;

cn.Open();

SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);