Use C# LINQ to return back all database names

Question

I am using MySQL and I need to loop through all the names of the schemas in MySQL and then return back as an array to allow me to loop through the names. How do I achieve this using LINQ?

var optionsBuilderForServerData = new DbContextOptionsBuilder<DataContext>()
   .UseMySql("server=localhost; user=user; password=password", 
   new MySqlServerVersion(new Version(8, 0, 21)));  

DataContext serverDataContext = new DataContext(optionsBuilderForServerData.Options);


var databaseNames = serverDataContext.  // what do I type here to view all database names?

If Linq does not have this ability, is there a way to achieve this using .SqlQuery() method?

I think you can find some helpful info here: stackoverflow.com/a/48419022/4954137 — kd345205
– kd345205, Commented Jun 18, 2021 at 16:32

Timur Umerov · Accepted Answer · 2021-06-18 17:09:49Z

1

It's not possible to do with LINQ. But you can try passing raw SQL string

"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA"

UPDATE

List<string> results = new List<string>();
using (var command =context.Database.GetDbConnection().CreateCommand())
{
     context.Database.OpenConnection();
     command.CommandText = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA";
     using (var reader = command.ExecuteReader())
     {
          while (reader.Read())
          {
               results.Add(reader.GetString(0));
          }
     }
}

This should work.

edited Jun 18, 2021 at 17:09

answered Jun 18, 2021 at 16:36

Timur Umerov

5073 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

GolfBravo Over a year ago

Can you please give me the full code. I keep getting error messages in mine. I have typed the below var dbNames = serverDataContext.Database.FromSqlRaw("SELECT name FROM master.dbo.sysdatabases").ToList(); but it says it does not contain a definition for 'FromSqlRaw'

Collectives™ on Stack Overflow

Use C# LINQ to return back all database names

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related