//***************************************************************************//
// Legenerálja a DA rétegbe egy entitás lekérdezését azonosító alapján       //
//***************************************************************************//
template GenerateLoadByID(MClass as ENTITY)
public override bool LoadEntity([ENTITY.name] entity, int entityId)
{
    return LoadById(entity, entityId);
}

public override bool FilteredLoadEntity([ENTITY.name] entity, int entityId, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
{
	return LoadById(entity, entityId, columnFilterMode, columns);
}

public bool LoadById([ENTITY.name] entity, int entityId)
{
	using (SDA.DataProvider.SDACommand command = dbhelper.CreateEmptyQueryCommand())
	{
        command.CommandText += " and ([ConvertNameToSQLTableName([ENTITY.name])].ID = :[ConvertNameToCommandParameterName("ID")]) ";
        command.Parameters.Add("[ConvertNameToCommandParameterName("ID")]", [GetCSharpSQLIDType()]).Value = entityId;
		return dbhelper.LoadSingleEntity(entity, command);
	}
}

public bool LoadById([ENTITY.name] entity, int entityId, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
{
	using (SDA.DataProvider.SDACommand command = dbhelper.CreateDynamicQueryCommand(columnFilterMode, columns))
	{
        command.CommandText += " and ([ConvertNameToSQLTableName([ENTITY.name])].ID = :[ConvertNameToCommandParameterName("ID")]) ";
        command.Parameters.Add("[ConvertNameToCommandParameterName("ID")]", [GetCSharpSQLIDType()]).Value = entityId;
		return dbhelper.LoadSingleEntity(entity, command, columnFilterMode, columns);
	}
}
end template