connectionstring

C#中Sqlsugar的使用教程:

   SqlSugar是一款国产的ORM框架，支持很多数据库，简单且好用。

  开源地址:网页链接

   优点有那些呢？

1、优越的性能

2、大量语法糖，拉姆达表达式筛选，多表查询,分页

3、支持NOLOCK查询，提高性能

4、支持事务

5、内置实体类生成函数，无需使用第三方代码生成器

6、简单好用

例如:

using(var db = new SqlSugarClient(ConnectionString)){

  var list=db.Queryable<T>().ToList();

}

//select single

var single = db.Queryable<Student>().Single(c => c.id == 1);

//select single by primarykey

var singleByPk = db.Queryable<Student>().InSingle(1);

//select single or default

var singleOrDefault = db.Queryable<Student>().SingleOrDefault(c => c.id == 11111111);

//select single or default

var single2 = db.Queryable<Student>().Where(c => c.id == 1).SingleOrDefault();

详细的用法可以看它的

官方文档:网页链接

#程序员# #IT# #编程#

#学习# #知识# #计算机#

System.Data.SqlClient.SqlException: 日结失败whf！

#it技术##计算机软件编程#System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnectionSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

DBHelper.SQLHelper.ExeProcedure(String storedProcName, IDataParameter[] parameters)

DAL.SQL.ShineDAL.ExeProcedure(String storedProcName, IDataParameter[] parameters)

BLL.ShineBLL.ExeProcedure(String storedProcName, IDataParameter[] parameters)

Inventory.frmDailySettlement.JS()#免费的零售收银系统软件好用吗?#