c# - 有没有办法从 C# 应用程序连接到 Magento 数据库？

Question

我想构建一个应用程序来使用 c# 访问(读/写)magento 数据库。我想知道有什么方法可以从自定义应用程序进行连接吗？如果是，哪个最好？请推荐我，因为我是 Magento 的新手，谢谢。

Answer 1

我使用 LINQPad (C#、VB.NET、F#)每天通过 SSH 隧道连接到我的 Magento 数据库。

有一个 MySQL 连接提供程序，可让您有效地将 LINQ to SQL 与 Magento 数据库结合使用。

然后我就可以运行查询，例如直接从 LINQPad 运行查询:

var items =
    from o in sales_flat_order
    where o.created_at > DateTime.Now.AddDays(-100)
    join i in sales_flat_order_item on o.entity_id equals i.order_id
    where i.sku.Contains(sku)
    join p in sales_flat_order_payment on o.entity_id equals p.parent_id
    orderby o.created_at descending
    select new
    {
        timestamp = o.created_at,
        order = o.increment_id,
        i.sku,
        i.name,
        qty = i.qty_ordered,
        o.status,
        p.method,
        i.row_total_incl_tax,
    };

然后，该工具可让您查看发送到数据库的实际查询。

SELECT t0.created_at, t0.increment_id, t1.sku, t1.name, t1.qty_ordered, t0.status, t2.method, t3.qty, t1.row_total_incl_tax
FROM sales_flat_order AS t0
INNER JOIN sales_flat_order_item AS t1
  ON (t0.entity_id = t1.order_id)
INNER JOIN sales_flat_order_payment AS t2
  ON (t0.entity_id = t2.parent_id)
INNER JOIN (
  SELECT t4.sku, t5.qty
  FROM catalog_product_entity AS t4
  INNER JOIN cataloginventory_stock_item AS t5
    ON (t4.entity_id = t5.product_id)
  WHERE (t4.sku LIKE CONCAT('%',@p0,'%'))
  ) AS t3
  ON (t1.sku = t3.sku)
WHERE ((t0.created_at > @p1) AND (t1.sku LIKE CONCAT('%',@p0,'%')))
ORDER BY t0.created_at DESC
-- p0 = [LEFCACP01]
-- p1 = [2015-08-07 16:13:31]

我还能够使用标准 .NET 控件来执行制图等操作。

我将它用于各种数据库报告和维护事件。