SQL代码-首先创建C#视图查询

using System;
using System.Data;
using System.Data.SqlClient;

namespace YourNamespace
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
            
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                
                string sqlQuery = "CREATE VIEW YourView AS SELECT * FROM YourTable";
                
                using (SqlCommand command = new SqlCommand(sqlQuery, connection))
                {
                    command.ExecuteNonQuery();
                    Console.WriteLine("View created successfully.");
                }
            }
        }
    }
}