///----------------------------------------------------------------------------------------- /// <summary> /// Run #1 : took 3,376 ms to insert 500,000 /// </summary> /// <returns></returns> public int InsertUsers(int newUserCount) { Stopwatch sw = new Stopwatch(); const string sqlCmd = "Insert DbDemo.Dbo.Ssn ( SsnId, Ssn1, Ssn2, Ssn3 ) " + "values( @ssnId, @ssn1, @ssn2, @ssn3 ) " + "Insert DbDemo.Dbo.Users ( FirstName, LastName, SsnId ) " + "values (@firstName, @lastName, @ssnId )"; var userList = CreateUserList(newUserCount, 1, 1, 1); int count = 0; sw.Restart(); foreach (var user in userList) { var parms = new Dahl.Data.SqlServer.CommandParameter { CreateParameter("@firstName", $"First{user.fk_Ssn.Ssn1:D3}-{user.fk_Ssn.Ssn2:d2}-{user.fk_Ssn.Ssn3:D4}"), CreateParameter("@lastName", $"Last{user.fk_Ssn.Ssn1:D3}-{user.fk_Ssn.Ssn2:d2}-{user.fk_Ssn.Ssn3:D4}"), CreateParameter("@ssnId", user.fk_Ssn.SsnId), CreateParameter("@ssn1", user.fk_Ssn.Ssn1), CreateParameter("@ssn2", user.fk_Ssn.Ssn2), CreateParameter("@ssn3", user.fk_Ssn.Ssn3) }; count += Database.ExecuteCommand(sqlCmd, parms); if (Database.LastError.Code != 0) { break; } } sw.Stop(); Trace.WriteLine($"InsertUsers -- Records Inserted: {count} --- Time to insert: {sw.ElapsedMilliseconds} ms"); return(count); }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <returns></returns> public Course GetCourse(string name) { const string sqlCmd = "select * from Courses where [Name] like @name"; var parms = new Dahl.Data.SqlServer.CommandParameter { CreateParameter("@name", name) }; var result = Database.ExecuteQuery <Course>(sqlCmd, parms)?.ToList(); if (result != null && !result.Any()) { return(null); } return(result?.ToList()[0]); }
public List <Models.Users> LoadOneUser() { const string sqlCmd = "select * from Users where LastName like @lastName "; var parms = new Dahl.Data.SqlServer.CommandParameter { CreateParameter("@lastName", "Last001-01-0002") }; Stopwatch sw = new Stopwatch(); sw.Restart(); var users = Database.ExecuteQuery(sqlCmd, parms, new Models.UsersMap()).ToList(); sw.Stop(); Trace.WriteLine($"LoadUsers(IDatabase database) ExecuteQuery returned {users.Count} user taking {sw.ElapsedMilliseconds:N0} ms."); Assert.IsNotNull(users); return(users); }