C# (CSharp) Common.Builders.SqlCommandBuilder.GetRecordsByField示例

示例#1

        public async Task <List <Chore> > GetAllChoresByChoreTypeId(short choretypeId)
        {
            var cmd = SqlCommandBuilder.GetRecordsByField(typeof(Chore), typeof(short), "ChoreTypeId", choretypeId.ToString());

            return(await _sqlClient.Get <Chore>(cmd));
        }

示例#2

        public async Task <List <Chore> > GetAllChoresByHouseId(string houseId)
        {
            var cmd = SqlCommandBuilder.GetRecordsByField(typeof(Chore), typeof(Guid), "HouseId", houseId);

            return(await _sqlClient.Get <Chore>(cmd));
        }