C# (CSharp) CustomerQueries.FromSqlRaw示例

示例#1

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            modelBuilder.Entity <Customer>().ToTable("Customers");
            modelBuilder.Entity <Employee>().ToTable("Employees");
            modelBuilder.Entity <Product>().ToTable("Products");
            modelBuilder.Entity <Order>().ToTable("Orders");
            modelBuilder.Entity <OrderDetail>().ToTable("Order Details");

            modelBuilder.Entity <CustomerOrderHistory>().HasKey(coh => coh.ProductName);
            modelBuilder.Entity <MostExpensiveProduct>().HasKey(mep => mep.TenMostExpensiveProducts);

#pragma warning disable CS0618 // Type or member is obsolete
            modelBuilder.Query <CustomerView>().HasNoKey().ToQuery(
                () => CustomerQueries.FromSqlRaw("SELECT * FROM Customers"));

            modelBuilder
            .Query <OrderQuery>()
            .ToQuery(
                () => Orders
                .FromSqlRaw(@"select * from ""Orders""")
                .Select(
                    o => new OrderQuery
            {
                CustomerID = o.CustomerID
            }));

            modelBuilder.Query <ProductQuery>().ToView("Alphabetical list of products");
#pragma warning restore CS0618 // Type or member is obsolete
        }