Pregunta sobre cómo pasar un parámetro dentro de una llamada de consulta de Dapper.

“`python
class Foo1:
_SQL1 = “SELECT UnitID, Name FROM Table1;”

XTable1 = []

def __init__(self):
    try:
        with System.Data.SqlClient.SqlConnection(ConnectDBString()) as _cnnDB:
            XTable1 = _cnnDB.Query<foo2>(_SQL1).AsList()
    except Exception as e:
        Console.WriteLine("Exception caught: {0}", e)

class Foo2:
_SQL2 = “SELECT Name FROM Table2 WHERE InitID = @XUnitId;”

XTable2 = []

def __init__(self):
    try:
        with System.Data.SqlClient.SqlConnection(ConnectDBString()) as _cnnDB:
            XTable2 = _cnnDB.Query<foo3>(_SQL2).AsList()
    except Exception as e:
        Console.WriteLine("Exception caught: {0}", e)

@property
def Name(self):
    return self._Name

@property
def UnitID(self):
    return self._ID

class Foo3:
def init(self):
pass

@property
def Name(self):
    return self._Name

class MyMain:
“””The main entry point for the application.”””
@STAThread
def Main():
theFoo = Foo1()

“””
I am learning the connections between Dapper and C#. I want to be able to have an internal list of sub classes defined within the parent class.
I would like the subclass to only have the data that is defined by the parent class that created it. I apologize for not yet having learned all the correct
terms for what I am doing. I need help trying to figure out how to get a parameter out of the select statement in foo1 and pass it to foo2. I have tried the
‘new’ command inside the Query command, but it seems that the data is not available when the Query is running. Can anyone point me to where I am not seeing
the correct way to code this?

I have cleaned up the code and it now compiles.
“””