FluentData.IntegrationTests/_Documentation/InsertUpdateDataTests.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using FluentData._Helpers;
using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace FluentData._Documentation
{
	[TestClass]
	public class InsertUpdateDataTests : BaseDocumentation
	{
		[TestMethod]
		public void Test()
		{
			var product = new Product();
			product.Name = "The Warren Buffet Way";
			product.CategoryId = 1;

			var insertBuilder = Context().Insert<Product>("Product", product);
			FillBuilder((IInsertUpdateBuilder<Product>) insertBuilder);
			product.ProductId = insertBuilder.ExecuteReturnLastId();

			Assert.IsTrue(product.ProductId > 0);

			var updateBuilder = Context().Update<Product>("Product", product);
			FillBuilder((IInsertUpdateBuilder<Product>) updateBuilder);

			int rowsAffected = updateBuilder.Where(x => x.ProductId).Execute();

			Assert.IsTrue(rowsAffected > 0);
		}

		public void FillBuilder(IInsertUpdateBuilder<Product> builder)
		{
			builder.Column(x => x.Name);
			builder.Column(x => x.CategoryId);
		}
	}
}