public virtual GlobalSetting GetByKey(String key)
{
var query = from o in Context.CreateQuery(EntityName)
where o.GetAttributeValue <String>(GlobalSettingEntity.KeyFieldName(_prefix)) == key
select new
{
Id = o.GetAttributeValue <Guid>(GlobalSettingEntity.IdFieldName(_prefix)),
Name = o.GetAttributeValue <String>(Common.CustomNameFieldName(_prefix)),
Key = o.GetAttributeValue <String>(GlobalSettingEntity.KeyFieldName(_prefix)),
Value = o.GetAttributeValue <String>(GlobalSettingEntity.ValueFieldName(_prefix)),
Type = o.GetAttributeValue <OptionSetValue>(GlobalSettingEntity.TypeFieldName(_prefix)),
ReferenceType = o.GetAttributeValue <String>(GlobalSettingEntity.ReferenceTypeFieldName(_prefix))
};
var array = query.ToArray();
return(array.Any() ? new GlobalSetting(_prefix)
{
Id = array[0].Id,
Key = array[0].Key,
Name = array[0].Name,
Value = array[0].Value,
Type = array[0].Type.ToEnum <GlobalSettingType>() ?? GlobalSettingType.String,
ReferenceType = array[0].ReferenceType
} : null);
}
public virtual IEnumerable <GlobalSetting> GetAll()
{
var query = from o in Context.CreateQuery(EntityName)
select new
{
Id = o.GetAttributeValue <Guid>(GlobalSettingEntity.IdFieldName(_prefix)),
Name = o.GetAttributeValue <String>(Common.CustomNameFieldName(_prefix)),
Key = o.GetAttributeValue <String>(GlobalSettingEntity.KeyFieldName(_prefix)),
Value = o.GetAttributeValue <String>(GlobalSettingEntity.ValueFieldName(_prefix)),
Type = o.GetAttributeValue <OptionSetValue>(GlobalSettingEntity.TypeFieldName(_prefix)),
ReferenceType = o.GetAttributeValue <String>(GlobalSettingEntity.ReferenceTypeFieldName(_prefix))
};
var array = query.ToArray();
return(array
.Select(o => new GlobalSetting(_prefix)
{
Id = o.Id,
Key = o.Key,
Name = o.Name,
Value = o.Value,
Type = o.Type.ToEnum <GlobalSettingType>() ?? GlobalSettingType.String,
ReferenceType = o.ReferenceType
}).ToArray());
}