Breaking News: Grepper is joining You.com. Read the official announcement!

Dapper 2 table join

Adventurous Ant answered on April 13, 2023 Popularity 3/10 Helpfulness 1/10

answer Dapper 2 table join

Dapper 2 table join

Comment

 public List<Model_Orders_received> GetOrders(int orderid2)
        {
            string sql = $"SELECT o.*,d.* from orders o LEFT JOIN ordersdetails d ON d.orderid = o.orderid  where o.orderid={orderid2}";

            var ProductDictionary = new Dictionary<int, Model_Orders_received>();

            using (IDbConnection dbConnection = new MySqlConnection(connection))
            {
                IEnumerable<Model_Orders_received> result = dbConnection.Query<Model_Orders_received, ordersdetails_received, Model_Orders_received>(sql, (prod, productVar) =>
                {
                    Model_Orders_received product;
                    if (!ProductDictionary.TryGetValue(prod.orderid, out product))
                    {
                        product = prod;
                        product.ordersdetails = new List<ordersdetails_received>();
                        ProductDictionary.Add(product.orderid, product);
                    }
                    if (productVar.orderid > 0) product.ordersdetails.Add(productVar);
                    return product;
                }, splitOn: "orderid");
               
                var products =result.Distinct().ToList();
                return products;
            }
         
        }

Popularity 3/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: dapper join whatever

Link to this answer
Share Copy Link

Contributed on Apr 13 2023

Adventurous Ant

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Dapper 2 table join

Contents

More Related Answers

Dapper 2 table join

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.