To use a stored procedure and retrieve a returned specific column, you have 3 choices:

1. By mapping returned data to an anonymous type and select your column:

language-csharp
 Copy code Copied!
using (var connection = new SqlConnection("connectionString"))
{
    var result = connection.Query("MyStoredProcedure", commandType: CommandType.StoredProcedure).ToList();
var specificColumnList = result.Select(x => (string)x.MyColumn).ToList();

}

2. By mapping returned data to a strongly typed object and select your column:

language-csharp
 Copy code Copied!
public class MyStoredProcedureResult
{
    public string MyColumn { get; set; }
// Add other properties as needed, to match all columns returned by the stored procedure

var specificColumnList = result.Select(x => x.MyColumn).ToList();

}

3. By using QueryMultiple (Multi-Mapping) and read returned data with an anonymous type or strongly typed object:

language-csharp
 Copy code Copied!
using (var connection = new SqlConnection("connectionString"))
{
    using (var multi = connection.QueryMultiple("MyStoredProcedure", commandType: CommandType.StoredProcedure))
    {
        var firstResultSet = multi.Read().ToList();
        var specificColumnFromFirstResultSet = firstResultSet.Select(x => (string)x.MyColumn).ToList();
    }
}