C# Data.SqlFilter类代码示例

 /// <summary>
 /// Gets entities where RowUpdatedUtc matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>RowUpdatedUtc</c>
 /// </remarks>
 public static ResourceCollection GetByRowUpdatedUtc(System.DateTime rowUpdatedUtc, BootFX.Common.Data.SqlOperator rowUpdatedUtcOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("RowUpdatedUtc", rowUpdatedUtcOperator, rowUpdatedUtc);
     ResourceCollection results = ((ResourceCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets the <see cref="Country"/> entity where the ID matches the given specification.
 /// </summary>
 public static Country GetById(int countryId, BootFX.Common.Data.SqlOperator countryIdOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Country));
     filter.Constraints.Add("CountryId", countryIdOperator, countryId);
     Country results = ((Country)(filter.ExecuteEntity()));
     return results;
 }

 /// <summary>
 /// Gets entities where Ordinal matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>Ordinal</c>
 /// </remarks>
 public static CountryCollection GetByOrdinal(int ordinal, BootFX.Common.Data.SqlOperator ordinalOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Country));
     filter.Constraints.Add("Ordinal", ordinalOperator, ordinal);
     CountryCollection results = ((CountryCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where Address2 matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>Address2</c>
 /// </remarks>
 public static ApiKeyCollection GetByAddress2(string address2, BootFX.Common.Data.SqlOperator address2Operator)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
     filter.Constraints.Add("Address2", address2Operator, address2);
     return ((ApiKeyCollection)(filter.ExecuteEntityCollection()));
 }

 /// <summary>
 /// Gets entities where City matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>City</c>
 /// </remarks>
 public static ApiKeyCollection GetByCity(string city, BootFX.Common.Data.SqlOperator cityOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
     filter.Constraints.Add("City", cityOperator, city);
     ApiKeyCollection results = ((ApiKeyCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where Subscribe matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>Subscribe</c>
 /// </remarks>
 public static ApiKeyCollection GetBySubscribe(bool subscribe, BootFX.Common.Data.SqlOperator subscribeOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
     filter.Constraints.Add("Subscribe", subscribeOperator, subscribe);
     ApiKeyCollection results = ((ApiKeyCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where LastName matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>LastName</c>
 /// </remarks>
 public static ApiKeyCollection GetByLastName(string lastName, BootFX.Common.Data.SqlOperator lastNameOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
     filter.Constraints.Add("LastName", lastNameOperator, lastName);
     ApiKeyCollection results = ((ApiKeyCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where CurrentMobileClientName matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>CurrentMobileClientName</c>
 /// </remarks>
 public static ResourceCollection GetByCurrentMobileClientName(string currentMobileClientName, BootFX.Common.Data.SqlOperator currentMobileClientNameOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("CurrentMobileClientName", currentMobileClientNameOperator, currentMobileClientName);
     ResourceCollection results = ((ResourceCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where ForceCodeCapture matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>ForceCodeCapture</c>
 /// </remarks>
 public static ResourceCollection GetByForceCodeCapture(bool forceCodeCapture, BootFX.Common.Data.SqlOperator forceCodeCaptureOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("ForceCodeCapture", forceCodeCaptureOperator, forceCodeCapture);
     ResourceCollection results = ((ResourceCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where ContractGroupId matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>ContractGroupId</c>
 /// </remarks>
 public static ResourceCollection GetByContractGroupId(int contractGroupId, BootFX.Common.Data.SqlOperator contractGroupIdOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("ContractGroupId", contractGroupIdOperator, contractGroupId);
     ResourceCollection results = ((ResourceCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where TargetMobileClientName matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>TargetMobileClientName</c>
 /// </remarks>
 public static ResourceCollection GetByTargetMobileClientName(string targetMobileClientName, BootFX.Common.Data.SqlOperator targetMobileClientNameOperator)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("TargetMobileClientName", targetMobileClientNameOperator, targetMobileClientName);
     return ((ResourceCollection)(filter.ExecuteEntityCollection()));
 }

 /// <summary>
 /// Gets entities where SecurityGroupId matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>SecurityGroupId</c>
 /// </remarks>
 public static ResourceCollection GetBySecurityGroupId(int securityGroupId, BootFX.Common.Data.SqlOperator securityGroupIdOperator)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("SecurityGroupId", securityGroupIdOperator, securityGroupId);
     return ((ResourceCollection)(filter.ExecuteEntityCollection()));
 }

 /// <summary>
 /// Gets entities where RowLastTransactionId matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>RowLastTransactionId</c>
 /// </remarks>
 public static ResourceCollection GetByRowLastTransactionId(System.Guid rowLastTransactionId, BootFX.Common.Data.SqlOperator rowLastTransactionIdOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("RowLastTransactionId", rowLastTransactionIdOperator, rowLastTransactionId);
     ResourceCollection results = ((ResourceCollection)(filter.ExecuteEntityCollection()));
     return results;
 }

 /// <summary>
 /// Gets entities where RowUpdatedUserId matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>RowUpdatedUserId</c>
 /// </remarks>
 public static ResourceCollection GetByRowUpdatedUserId(int rowUpdatedUserId, BootFX.Common.Data.SqlOperator rowUpdatedUserIdOperator)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("RowUpdatedUserId", rowUpdatedUserIdOperator, rowUpdatedUserId);
     return ((ResourceCollection)(filter.ExecuteEntityCollection()));
 }

 /// <summary>
 /// Gets entities where PasswordHash matches the given specification.
 /// </summary>
 /// <remarks>
 /// Created for column <c>PasswordHash</c>
 /// </remarks>
 public static ApiKeyCollection GetByPasswordHash(string passwordHash, BootFX.Common.Data.SqlOperator passwordHashOperator, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
     filter.Constraints.Add("PasswordHash", passwordHashOperator, passwordHash);
     ApiKeyCollection results = ((ApiKeyCollection)(filter.ExecuteEntityCollection()));
     return results;
 }