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); } }
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(); } }
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); } }
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(); }
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); } }); }
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(); }
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); } }