title: Read list of strings from MySQL Stored Proc in .NET 6
body: <p>I have a MySQL (not SQL Server) database with a Stored Procedure that returns a tabular result with one (1) column of strings.</p>
  <p>I would like to get that result into my .NET application as some sort of <code>IEnumerable&lt;string&gt;</code> or <code>List&lt;string&gt;</code> etc.</p>
  <p>What do?</p>
  <p>I've tried playing with <a href="https://www.nuget.org/packages/MySql.EntityFrameworkCore/" rel="nofollow noreferrer">MySql.EntityFrameworkCore</a> but get stuck quickly. Entity Framework Core either wants to generate tables based on models or models based on tables. I want neither. I just want my strings, plain and simple.</p>
  <p>I've tried making a POCO with a single property and the <code>[Keyless]</code> attribute but no dice. If I define a <code>DbSet&lt;Poco&gt;</code> then the table doesn't exist, if I try to do <code>context.Set&lt;Poco&gt;().FromSql('call my_stored_proc();');</code> then EF core complains the DbSet doesn't exist.</p>
  <p>I'm using .NET 6 and the latest versions of above mentioned MySQL EntityFrameworkCore NuGet. Searching for answers is made harder by a lot of answers either assuming SQL Server or using older versions of EF core with methods that my EF core doesn't seem to have. And some results claim that EF core 6 doesn't work with .NET 6?</p>
  <p>I'm also happy bypassing EF entirely if that's easier.</p>