public static void Main()
        {
            using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection))
            {
                sqlConnection.Open();

                var entity = sqlConnection.Get<Supplier>(9);
                entity.ContactName = "John Smith";

                sqlConnection.Update<Supplier>(entity);

                var result = sqlConnection.Get<Supplier>(9);

                ObjectDumper.Write(result.ContactName);
            }
        }
示例#2
0
 public Usuario BuscarUsuario(int UsuarioId)
 {
     //string sql = "Select * from TB_Usuario Where USUID=@USUID";
     using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(Conexao01))
     {
         conn.Open();
         return(conn.Get <Usuario>(UsuarioId));
         //return conn.Query<Usuario>(sql,new{USUID=UsuarioId}).FirstOrDefault();
     }
 }
示例#3
0
 public Fornecedor BuscarFornecedor(int FornecedorId)
 {
     //string sql = "Select * from TB_Fornecedor Where FORNID=@FORNID";
     using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(Conexao01))
     {
         conn.Open();
         return(conn.Get <Fornecedor>(FornecedorId));
         //return conn.Query<Fornecedor>(sql,new{FORNID=FornecedorId}).FirstOrDefault();
     }
 }
        public static void Main()
        {
            using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection))
            {
                sqlConnection.Open();

                var result = sqlConnection.Get<Supplier>(9);

                ObjectDumper.Write(result);
            }
        }
示例#5
0
		public static void UpdatesWithChangeTracking()
		{
			using (var cn = new SqlConnection(CONNECTION_STRING))
			{
				var contact = cn.Get<IContact>(1);
				Console.WriteLine("Update occurred: {0}", cn.Update(contact));
				
				contact.FirstName = "J.";
				Console.WriteLine("Update occurred: {0}", cn.Update(contact));
			}

			Console.ReadKey();
		}
示例#6
0
        private static void Dapper(int eachCount)
        {
            GC.Collect();//回收资源
            System.Threading.Thread.Sleep(2000);//休息2秒

            //正试比拼
            PerHelper.Execute(eachCount, "Dapper", () =>
            {
                using (SqlConnection conn = new SqlConnection(PubConst.connectionString))
                {
                    var list = conn.Get<Test>(1000);
                }
            });
        }
示例#7
0
		public static void Update()
		{
			using (var cn = new SqlConnection(CONNECTION_STRING))
			{
				cn.Open();

				var c = cn.Get<Contact>(1);
				c.FirstName = "Jonathan";

				var updated = cn.Update(c);

				Console.WriteLine("Updated {0}", updated);
			}

			Console.ReadKey();
		}
示例#8
0
		public static void GetMethods()
		{
			using (var cn = new SqlConnection(CONNECTION_STRING))
			{
				var contact = cn.Get<Contact>(1);
				var contacts = cn.GetAll<Contact>();

				Console.WriteLine(
					"Found contact {0} {1} and {2} total contacts",
					contact.FirstName,
					contact.LastName,
					contacts.Count());
			}

			Console.ReadKey();
		}
        public void TestPersonWithIdIsOne()
        {
            IPerson mockPerson = table.GetTable().First(p => p.Id == 1);

            using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
            {
                conn.Open();

                var person = conn.Get<Person>("Select Id,Name From PERSON Where Id = @Id", new { Id = 1 });

                Assert.IsNotNull(person);

                Assert.AreEqual(mockPerson.Id, person.Id);
                Assert.AreEqual(mockPerson.Name, person.Name);
            }
        }
        public static void Main()
        {
            using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection))
            {
                sqlConnection.Open();

                // using interface to track "Isdirty"
                var supplier = sqlConnection.Get<ISupplier>(9);
                //supplier.CompanyName = "Manning";

                // should return false, becasue there is no change.
                ObjectDumper.Write(string.Format("Is Update {0}", sqlConnection.Update(supplier)));

                supplier.CompanyName = "Manning";

                // should return true
                ObjectDumper.Write(string.Format("Is Update {0}", sqlConnection.Update(supplier)));

            }
        }
        public void GetAllWithId5()
        {
            IPerson mockPerson = table.GetTable().First(p => p.Id == 5);

            using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
            {
                conn.Open();

                var person = conn.Get<Person>("Select * From PERSON Where Id = @Id", new { Id = 5 });

                Assert.IsNotNull(person);

                Assert.AreEqual(mockPerson.Id, person.Id);
                Assert.AreEqual(mockPerson.Name, person.Name);
                Assert.AreEqual(mockPerson.DateOfBirth, person.DateOfBirth);
                Assert.AreEqual(mockPerson.SSN, person.SSN);
                Assert.AreEqual(mockPerson.BankAccount, person.BankAccount);
                Assert.AreEqual(mockPerson.NoofCars, person.NoofCars);
                Assert.AreEqual(mockPerson.IsPremium, person.IsPremium);
            }
        }
        /// <summary>
        /// Customers the CRUD.
        /// </summary>
        /// <param name="sqlconn">The sqlconn.</param>
        /// <remarks>http://wintersun.cnblogs.com/</remarks>
        private static void CustomerCRUD(SqlConnection sqlconn)
        {
            var customer = new Customers
            {
                CustomerID = "8273",
                CompanyName = "Newcompanyname",
                ContactName = "ccc",
                Address = "asdcasdws",
                ContactTitle = "asdf",
                City = "kuna",
                Country = "china",
                Fax = "23",
                Phone = "231",
                PostalCode = "234",
                Region = "asia"
            };

            string insertflag = sqlconn.Insert<Customers>(customer);

            //update it
            var myCustomer = sqlconn.Get<Customers>(customer.CustomerID);
            myCustomer.ContactName = "updated name";

            sqlconn.Update<Customers>(myCustomer);

            //delete
            sqlconn.Delete<Customers>(customer);
        }
        public void NullName()
        {
            using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
            {
                conn.Open();

                var person = conn.Get<Person>("Select NULL As Name");

                Assert.IsNotNull(person);
                Assert.AreEqual(null, person.Name);

            }
        }