SET COLLATE ชอง SQL SERVER ผ่าน ENTITY FRAMEWORK แบบเอาให้มั่น คั้นให้อยู่มือกันเลยน่ะครับ

         public static void SQLServerSetDatabaseCollation
           (string ConnectionString, string DatabaseName, string SpecificCollation = "Thai_CI_AS")
        {
            //ref https://www.thaicreate.com/dotnet/forum/062440.html                        
            string tempStr = string.Empty;
            StringBuilder sb = new StringBuilder();

            // WITH SQL-DDL COMMAND NOT ALLOW PASS VALUE FROM PARAMETER            
            // ENTITY.EXECUTESQLCOMMAND NOT SUPPORT ALTER COMMAND THEIR YIELD ERROR WITH CONNECTION RESET
            // THEN EXECUTE PASSTHROUGH TRADDITION (ASYNC)ADO.NET
            sb.Append("IF DB_ID('"+ DatabaseName + "') IS NOT NULL");
            sb.Append("BEGIN");
            sb.Append("   ALTER DATABASE " + DatabaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE;");
            sb.Append("   ALTER DATABASE " + DatabaseName + " COLLATE " + SpecificCollation + ";");
            sb.Append("   ALTER DATABASE " + DatabaseName + " SET MULTI_USER;");
            sb.Append("END ;");

            tempStr = sb.ToString();

            // USE ASYNC CALL PREVENTS ALL RESULT HAVE COMPLETED ONE BY ONE.
            SqlServerAsyncExecuteCommandWithADODotNet(ConnectionString, tempStr)
                .ContinueWith(t => Console.WriteLine(t.Exception)
                    , TaskContinuationOptions.OnlyOnFaulted);

        }

        public static void SQLServerSetDatabaseCollation
            (this SqlConnectionStringBuilder SpecificConnectionBuilder, string SpecificCollation = "Thai_CI_AS")
        {
            SQLServerSetDatabaseCollation(SpecificConnectionBuilder.ConnectionString
                , SpecificConnectionBuilder.InitialCatalog, SpecificCollation);
        }

        public static void SQLServerSetDatabaseCollation<TContext>
         (this TContext Context, string SpecificCollation = "Thai_CI_AS")
            where TContext : DbContext
        {
            SQLServerSetDatabaseCollation(Context.Database.Connection.ConnectionString
                , Context.Database.Connection.Database, SpecificCollation);
        }

        public static async Task<int> SqlServerAsyncExecuteCommandWithADODotNet(string ConnectionString
            , string CommandText, params object[] Parameters)
        {
            int iret = 0;
            string tempStr = CommandText;
            string ParamName = string.Empty;
            try
            {
                using (var conn = new SqlConnection(ConnectionString))
                {
                    using (var cmd = conn.CreateCommand())
                    {
                        for (int i = 0; i < Parameters.Length; i++)
                        {
                            ParamName = "@param" + (i + 1).ToString();
                            tempStr = tempStr.Replace("{" + i.ToString() + "}", ParamName);
                            cmd.Parameters.AddWithValue(ParamName, Parameters[i]);
                        }
                        cmd.CommandText = tempStr;
                        await conn.OpenAsync();
                        await cmd.ExecuteNonQueryAsync();
                        iret = 1;
                    }
                }
            }
            catch (SqlException e)//(Exception e)
            {
                //Debug.WriteLine("At SqlServerAsyncExecuteCommandWithADODotNet : [" + e.Message + "]");
                iret = -1;
            }
            return iret;
        }

        public CreateDatabaseIfNotExistsWithCollationEx(TContext context, string Collation = "Thai_CI_AS")
        {
            if (!context.Database.Exists())
            {
                context.Database.CreateIfNotExists();
                context.SQLServerSetDatabaseCollation<TContext>(Collation);
            }

        }

        public static string SQLServerGetDatebaseCollation<TContext>(this TContext SpecificDBContext)
            where TContext : DbContext
        {
            StringBuilder sb = new StringBuilder();
            string DatabaseName = SpecificDBContext.Database.Connection.Database;            

            sb.AppendLine("SELECT collation_name");
            sb.AppendLine("FROM sys.databases");
            sb.AppendLine("WHERE [name] = @databaseName;");

            var DatabaseNameParam = new SqlParameter("@databaseName", DatabaseName);

            //for debug only
            String str = sb.ToString();

            str = SpecificDBContext.Database.SqlQuery<string>
                (str, DatabaseNameParam).FirstOrDefault<string>();

            return str;
        }