using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace XMLMappingDemo.PO
{
    public class Customer
    {
        public int Id { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
    }
}

    class DemoContext:DbContext
    {
        static DbConfiguration configuration = DbConfiguration.ConfigureSqlCe35("Db.sdf")
            .SetSqlLogger(() => new SqlLog(Console.Out))
            .AddFile(@"Mappings\Customer.mapping.xml")
            ;

        public DemoContext() : base(configuration) { }

        public IDbSet<Customer> Customers { get; set; }
    }

        [Test]
        public void ClearAll()
        {
            using (var db = new DemoContext())
            {
                db.Customers.Delete(p => true);
                Assert.AreEqual(0, db.Customers.Count());
            }
        }

DELETE FROM [Customer]
WHERE  1=1 

SELECT COUNT(*)
FROM [Customer] AS t0

//插入
var customer = new Customer { FirstName = "风云", LastName = "王" };
Assert.AreEqual(0, customer.Id);
db.Customers.Insert(customer);
Assert.IsTrue(customer.Id > 0);

INSERT INTO [Customer]([FirstName], [LastName])
VALUES (@p0, @p1)
-- p0:(DbType = String,Value = 风云)
-- p1:(DbType = String,Value = 王)

SELECT @@IDENTITY AS [Id]

                //查询
                var items = from c in db.Customers
                            where c.FirstName == "风云"
                            select c;

                var tb = Mapper.Map<IQueryable<Customer>, DataTable>(items);

                tb.WriteXml(Console.Out);

SELECT t0.[Id], t0.[FirstName], t0.[LastName]
FROM [Customer] AS t0
WHERE (t0.[FirstName] = @p0)
-- p0:(DbType = String,Value = 风云)

<DocumentElement>
  <Customer>
    <Id>9</Id>
    <FirstName>风云</FirstName>
    <LastName>王</LastName>
  </Customer>
</DocumentElement>

customer.LastName = "dd";
var effectedRow = db.Customers.Update(customer);
 Assert.AreEqual(1, effectedRow);

UPDATE [Customer]
SET [FirstName] = @p0, [LastName] = @p1
WHERE (([Id]=9))
-- p0:(DbType = String,Value = 风云)
-- p1:(DbType = String,Value = dd)

//查询
items = from c in db.Customers
        where c.FirstName == "风云"
        select c;

 tb = Mapper.Map<IQueryable<Customer>, DataTable>(items);

 tb.WriteXml(Console.Out);

SELECT t0.[Id], t0.[FirstName], t0.[LastName]
FROM [Customer] AS t0
WHERE (t0.[FirstName] = @p0)
-- p0:(DbType = String,Value = 风云)

<DocumentElement>
  <Customer>
    <Id>9</Id>
    <FirstName>风云</FirstName>
    <LastName>dd</LastName>
  </Customer>
</DocumentElement>

db.Customers.Delete(p => p.Id == customer.Id);
Assert.AreEqual(0, db.Customers.Count());

DELETE FROM [Customer]
WHERE (([Id]=9))

SELECT COUNT(*)
FROM [Customer] AS t0