Closed
Description
FreeSql 1.8.1
初始化:
IFreeSql freeSql = new FreeSql.FreeSqlBuilder()
.UseConnectionString(FreeSql.DataType.Oracle, connectionStrings.DefaultConnection)
.UseNameConvert(FreeSql.Internal.NameConvertType.ToUpper)
.UseGenerateCommandParameterWithLambda(true)
.UseMonitorCommand(cmd =>
LogHelper.Debug(cmd.CommandText)
)
.Build();实体类代码:
[Table(Name = "V_HospitalReport")]
public class V_HospitalReport
{
[Column(Name = "hospital_name")]
public string HospitalName { get; set; }
[Column(Name = "dep")]
public string Dep { get; set; }
[Column(Name = "instrna")]
public string Instrna { get; set; }
[Column(Name = "confirm_doctor_name")]
public string ConfirmDoctorName { get; set; }
[Column(Name = "Scheduled_Dttm")]
public DateTime ScheduledDttm { get; set; }
}
public class TotalDto
{
public long DayNum { get; set; }
public long TotalNum { get; set; }
}查询代码:
DateTime dateTime = DateTime.Now;
ISelect<V_HospitalReport> select1 = freeSql.Select<V_HospitalReport>();
ISelect<V_HospitalReport> select2 = freeSql.Select<V_HospitalReport>();
await freeSql.Select<V_HospitalReport>().ToOneAsync(a =>
new TotalDto
{
TotalNum = select1.Count(),
DayNum = select2.Where(b => b.ScheduledDttm.Date == dateTime.Date).Count()
});Metadata
Metadata
Assignees
Labels
No labels