C# SqlFilter.ExecuteEntity方法代码示例

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

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

 /// <summary>
 /// Gets an entity where CustomerId and ExternalId are equal to the given values.
 /// </summary>
 /// <remarks>
 /// Created for index <c>IX_ShmResources</c>.
 /// </remarks>
 public static Resource GetByCustomerIdAndExternalId(int customerId, string externalId, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
     filter.Constraints.Add("CustomerId", BootFX.Common.Data.SqlOperator.EqualTo, customerId);
     filter.Constraints.Add("ExternalId", BootFX.Common.Data.SqlOperator.EqualTo, externalId);
     Resource results = ((Resource)(filter.ExecuteEntity()));
     return results;
 }

 /// <summary>
 /// Gets an entity where Username and ApiKeyId are equal to the given values.
 /// </summary>
 /// <remarks>
 /// Created for index <c>Users_Username</c>.
 /// </remarks>
 public static UserItem GetByUsernameAndApiKeyId(string username, int apiKeyId, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(UserItem));
     filter.Constraints.Add("Username", BootFX.Common.Data.SqlOperator.EqualTo, username);
     filter.Constraints.Add("ApiKeyId", BootFX.Common.Data.SqlOperator.EqualTo, apiKeyId);
     UserItem results = ((UserItem)(filter.ExecuteEntity()));
     return results;
 }

 /// <summary>
 /// Gets an entity where ApiKeyId and Email are equal to the given values.
 /// </summary>
 /// <remarks>
 /// Created for index <c>Users_ApiEmail</c>.
 /// </remarks>
 public static UserItem GetByApiKeyIdAndEmail(int apiKeyId, string email, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(UserItem));
     filter.Constraints.Add("ApiKeyId", BootFX.Common.Data.SqlOperator.EqualTo, apiKeyId);
     filter.Constraints.Add("Email", BootFX.Common.Data.SqlOperator.EqualTo, email);
     UserItem results = ((UserItem)(filter.ExecuteEntity()));
     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 the <see cref="CustomField"/> entity where the ID matches the given specification.
 /// </summary>
 public static CustomField GetById(int customFieldId, BootFX.Common.Data.SqlOperator customFieldIdOperator)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(CustomField));
     filter.Constraints.Add("CustomFieldId", customFieldIdOperator, customFieldId);
     return ((CustomField)(filter.ExecuteEntity()));
 }

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

 /// <summary>
 /// Gets an entity where CustomFieldId and ObjectId are equal to the given values.
 /// </summary>
 /// <remarks>
 /// Created for index <c>CustomData_CustomFieldIdObjectId</c>.
 /// </remarks>
 public static CustomData GetByCustomFieldIdAndObjectId(int customFieldId, long objectId, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(CustomData));
     filter.Constraints.Add("CustomFieldId", BootFX.Common.Data.SqlOperator.EqualTo, customFieldId);
     filter.Constraints.Add("ObjectId", BootFX.Common.Data.SqlOperator.EqualTo, objectId);
     CustomData results = ((CustomData)(filter.ExecuteEntity()));
     return results;
 }

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

 /// <summary>
 /// Gets an entity where TargetTypeName is equal to the given value.
 /// </summary>
 /// <remarks>
 /// Created for index <c>TableCatalogItems_TargetTypeName</c>.
 /// </remarks>
 public static TableCatalogItem GetByTargetTypeName(string targetTypeName, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(TableCatalogItem));
     filter.Constraints.Add("TargetTypeName", BootFX.Common.Data.SqlOperator.EqualTo, targetTypeName);
     TableCatalogItem results = ((TableCatalogItem)(filter.ExecuteEntity()));
     return results;
 }

 /// <summary>
 /// Gets an entity where Token is equal to the given value.
 /// </summary>
 /// <remarks>
 /// Created for index <c>LogonTokens_Token</c>.
 /// </remarks>
 public static LogonToken GetByToken(string token, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(LogonToken));
     filter.Constraints.Add("Token", BootFX.Common.Data.SqlOperator.EqualTo, token);
     LogonToken results = ((LogonToken)(filter.ExecuteEntity()));
     return results;
 }

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

 /// <summary>
 /// Gets an entity where ShmCustomerId, Name and TableCatalogId are equal to the given values.
 /// </summary>
 /// <remarks>
 /// Created for index <c>CustomFields_CustomerIdTableCatalogIdName</c>.
 /// </remarks>
 public static CustomField GetByShmCustomerIdAndNameAndTableCatalogId(int shmCustomerId, string name, int tableCatalogId, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(CustomField));
     filter.Constraints.Add("ShmCustomerId", BootFX.Common.Data.SqlOperator.EqualTo, shmCustomerId);
     filter.Constraints.Add("Name", BootFX.Common.Data.SqlOperator.EqualTo, name);
     filter.Constraints.Add("TableCatalogId", BootFX.Common.Data.SqlOperator.EqualTo, tableCatalogId);
     CustomField results = ((CustomField)(filter.ExecuteEntity()));
     return results;
 }

 /// <summary>
 /// Gets an entity where Username is equal to the given value.
 /// </summary>
 /// <remarks>
 /// Created for index <c>ApiKeys_Username</c>.
 /// </remarks>
 public static ApiKey GetByUsername(string username, BootFX.Common.OnNotFound onNotFound)
 {
     BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
     filter.Constraints.Add("Username", BootFX.Common.Data.SqlOperator.EqualTo, username);
     ApiKey results = ((ApiKey)(filter.ExecuteEntity()));
     return results;
 }