FluentData.IntegrationTests/_Documentation/SampleCodeTests.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System.Collections.Generic;
using FluentData._Helpers;
using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace FluentData._Samples
{
	[TestClass]
	public class SampleCode
	{
		protected IDbContext Context()
		{
			return TestHelper.Context();
		}

		[TestMethod]
		public void Get_a_single_product()
		{
			Product product = Context().Sql(@"select *	from Product where ProductId = 1").QuerySingle<Product>();

			Assert.IsNotNull(product);
		}

		[TestMethod]
		public void Get_many_products()
		{
			List<Product> products = Context().Sql(@"select * from Product").Query<Product>();

			Assert.IsTrue(products.Count > 0);
		}

		[TestMethod]
		public void Insert_a_new_product()
		{
			var productId = Context().Insert("Product")
										.Column("Name", "The Warren Buffet Way")
										.Column("CategoryId", 1)
										.ExecuteReturnLastId();

			Assert.IsTrue(productId > 0);
		}

		[TestMethod]
		public void Insert_a_new_product_sql()
		{
			var productId = Context().Sql(@"insert into Product(Name, CategoryId)
											values('The Warren Buffet Way', 1);").ExecuteReturnLastId();

			Assert.IsTrue(productId > 0);
		}

		[TestMethod]
		public void Update_existing_product()
		{
			var rowsAffected = Context().Update("Product")
									.Column("Name", "The Warren Buffet Way")
									.Column("CategoryId", 1)
									.Where("ProductId", 1)
									.Execute();

			Assert.IsTrue(rowsAffected > 0);