//---------------------------------------------------------------------------------------------------------------------
public static RemoteResource FromId(IfyContext context, int id)
{
RemoteResource result = new RemoteResource(context);
result.Id = id;
result.Load();
return(result);
}
//---------------------------------------------------------------------------------------------------------------------
public static RemoteResourceEntityCollection GetResources(IfyContext context, RemoteResourceSet resourceSet)
{
RemoteResourceEntityCollection result = new RemoteResourceEntityCollection(context);
result.Template.ResourceSet = resourceSet;
IDbConnection dbConnection = context.GetDbConnection();
IDataReader reader = context.GetQueryResult(String.Format("SELECT t.id, t.location, t.name FROM resource AS t WHERE id_set={0}", resourceSet.Id), dbConnection);
while (reader.Read())
{
RemoteResource resource = new RemoteResource(context);
resource.Id = reader.GetInt32(0);
resource.ResourceSet = resourceSet;
resource.Location = reader.GetString(1);
resource.Name = reader.GetString(2);
}
context.CloseQueryResult(reader, dbConnection);
return(result);
}