LambdaToSql/DbHelper/IDBhelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace LambdaToSql.DbHelper
{
    public interface IDBhelper
    {
        #region IDataReader

        /// <summary>
        /// 返回IDataReader
        /// </summary>
        /// <param name="sqlStr">sql语句</param>
        /// <param name="parameter">object参数数组</param>
        /// <returns>返回IDataReader</returns>
        IDataReader ExecuteReader(string sqlStr, object parameter = null);

        /// <summary>
        /// 返回 IDataReader
        /// </summary>
        /// <param name="sqlStr">sql语句</param>
        /// <param name="parameters">object参数数组</param>
        /// <returns>返回值 IDataReader类型的参数</returns>
        IDataReader ExecuteReader(string sqlStr, object[] parameters);

        #endregion IDataReader

        #region DataTable

        /// <summary>
        /// 返回 DataTable
        /// </summary>
        /// <param name="sqlStr">sql语句</param>
        /// <param name="parameter">object参数数组</param>
        /// <returns>返回值 DataTable类型的参数</returns>
        DataTable ExecuteTable(string sqlStr, object parameter = null);

        /// <summary>
        /// 返回 DataTable
        /// </summary>
        /// <param name="sqlStr">sql语句</param>
        /// <param name="parameters">object参数数组</param>
        /// <returns>返回值 DataTable类型的参数</returns>
        DataTable ExecuteTable(string sqlStr, object[] parameters);

        #endregion

        #region ExecuteScalar

        /// <summary>
        /// 返回 object
        /// </summary>
        /// <param name="sqlStr">sql语句</param>
        /// <param name="parameter">object参数数组</param>
        /// <returns>返回值 int类型的参数</returns>