public void RemoveCustomer(Customer customer)
 {
     using (var connection = new SqlConnection(_connectionString))
     {
         connection.Open();
         connection.Delete(CustomerTableName, new KeyValuePair<string, object>("客户号", customer.客户号));
     }
 }
Example #2
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 delList = GetDeleteList();
                    var list = conn.Delete(delList);
                }
            });
        }
Example #3
0
        static void Main()
        {
            try
            {
                var connection = new SqlConnection(@"Server=localhost\sqlexpress;Database=ExperimentalStuff;Trusted_Connection=true;");

                var id = new Guid("DB44BD6A-532C-4F9A-A9A0-CE32C193F467");
                var grandParent = new GrandParent
                {
                    Id = id,
                    Name = "grandparent",
                };

                Builder<Parent>.CreateListOfSize(3).Build()
                    .ToList().ForEach(grandParent.AddParent);

                connection.Open();
                using (var transaction = connection.BeginTransaction())
                {
                    connection.Delete<GrandParent>(new { grandParent.Id }, transaction);
                    var insert = connection.Insert(grandParent, transaction);
                    Console.WriteLine(insert);
                    transaction.Commit();
                }
                connection.Close();

                Print(connection, grandParent.Id);
                //connection.Delete<GrandParent>(new { grandParent.Id });

                connection.Dispose();
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception);
            }
            finally
            {
                Console.WriteLine("Press any key to exit.");
                Console.ReadKey();
            }
        }
        /// <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 bool RemoveRoleFromUser(int roleId, int userId)
        {
            using (var conn = new SqlConnection(ConnectionString))
            {
                var recordsAffected =
                    conn.Delete<UserRole>(new Dictionary<string, object>()
                    {
                        {"Id", userId},
                        {"RoleId", roleId}
                    });

                return recordsAffected.Equals(1);
            }
        }
        public bool RemoveRoleFromRole(int roleId, int parentId)
        {
            using (var conn = new SqlConnection(ConnectionString))
            {
                var recordsAffected =
                    conn.Delete<RoleRole>(new Dictionary<string, object>()
                    {
                        {"RoleId", roleId},
                        {"ParentRoleId", parentId}
                    });

                return recordsAffected.Equals(1);
            }
        }
        public bool RemoveActivityFromRole(int activityId, int roleId)
        {
            using (var conn = new SqlConnection(ConnectionString))
            {
                var recordsAffected =
                    conn.Delete<RoleActivity>(new Dictionary<string, object>()
                    {
                        {"ActivityId", activityId},
                        {"RoleId", roleId}
                    });

                return recordsAffected.Equals(1);
            }
        }
        public void delete_offer_deletes_equipment_offer_descendents()
        {
            var offerGuid = Guid.NewGuid();
            var equipmentOfferGuid = Guid.NewGuid();
            var offer = new OfferDto
            {
                OfferGuid = offerGuid,
                Equipment = new List<EquipmentOfferTrnDao>
                {
                    new EquipmentOfferTrnDao
                    {
                        EquipmentOfferGuid = equipmentOfferGuid,
                        OfferGuid = offerGuid,
                        EquipmentOptions = new List<EquipmentOptionTrnDao>
                        {
                            new EquipmentOptionTrnDao
                            {
                                EquipmentOptionTrnGuid = Guid.NewGuid(),
                                EquipmentOfferGuid = equipmentOfferGuid,
                                Quantity = 23
                            }
                        }
                    }
                },
                OfferReference = "Test offer",
                OpportunityGuid = Guid.NewGuid()
            };

            var logger = new MockSimpleSaveLogger();
            SimpleSaveExtensions.Logger = logger;
            
            try
            {
                using (IDbConnection connection = new SqlConnection())
                {
                    connection.Delete(offer);
                }
            }
            catch (InvalidOperationException)
            {
                //  Don't care
            }

            var scripts = logger.Scripts;
            Assert.AreEqual(1, scripts.Count, "Unexpected number of scripts.");

            var sql = scripts[0].Buffer.ToString();

            var deleteFromEquipmentOptionIndex = sql.IndexOf("DELETE FROM [opp].[EQUIPMENT_OPTION_TRN]");
            Assert.IsTrue(deleteFromEquipmentOptionIndex >= 0, "No delete from [opp].[EQUIPMENT_OPTION_TRN]");

            var deleteFromEquipmentOfferIndex = sql.IndexOf("DELETE FROM [opp].[EQUIPMENT_OFFER_TRN]");
            Assert.IsTrue(deleteFromEquipmentOfferIndex >= 0, "No delete from [opp].[EQUIPMENT_OFFER_TRN]");

            var deleteFromOfferIndex = sql.IndexOf("DELETE FROM [opp].[OFFER_TRN]");
            Assert.IsTrue(deleteFromOfferIndex >= 0, "No delete from [opp].[OFFER_TRN]");

            Assert.IsTrue(
                deleteFromEquipmentOptionIndex < deleteFromEquipmentOfferIndex,
                "Delete from [opp].[EQUIPMENT_OPTION_TRN] should appear before delete from [opp].[EQUIPMENT_OFFER_TRN]");

            Assert.IsTrue(
                deleteFromEquipmentOfferIndex < deleteFromOfferIndex,
                "Delete from [opp].[EQUIPMENT_OFFER_TRN] should appear before delete from [opp].[OFFER_TRN]");
        }
 public void RemoveCustomerContact(CustomerContact contact)
 {
     using (var connection = new SqlConnection(_connectionString))
     {
         connection.Open();
         connection.Delete(CustomerContactTableName, new KeyValuePair<string, object>("姓名", contact.姓名));
     }
 }
 public void RemoveInventor(Inventor inventor)
 {
     using (var connection = new SqlConnection(_connectionString))
     {
         connection.Open();
         connection.Delete(InventorTableName, new KeyValuePair<string, object>("身份证号", inventor.身份证号));
     }
 }
 public void RemoveApplicant(Applicant applicant)
 {
     using (var connection = new SqlConnection(_connectionString))
     {
         connection.Open();
         connection.Delete(ApplicantTableName, new KeyValuePair<string, object>("证件号", applicant.证件号));
     }
 }