private bool CreateCompany( string companyName, string currentLogonName, string firstName, string lastName, string logonEmailAddress, string telephone, string password) { DbCommand sqlCommand = SqlDataManager.CreateCommand(); sqlCommand.CommandText = "dbo.CompanyProvision"; DbParameter paramTemp = sqlCommand.CreateParameter(); paramTemp.ParameterName = "@pCompanyName"; paramTemp.Value = companyName; paramTemp.DbType = DbType.String; sqlCommand.Parameters.Add(paramTemp); paramTemp.ParameterName = "@pCurrentLogonName"; paramTemp.Value = companyName; paramTemp.DbType = DbType.String; sqlCommand.Parameters.Add(paramTemp); paramTemp.ParameterName = "@pFirstName"; paramTemp.Value = companyName; paramTemp.DbType = DbType.String; sqlCommand.Parameters.Add(paramTemp); paramTemp.ParameterName = "@pLastName"; paramTemp.Value = companyName; paramTemp.DbType = DbType.String; sqlCommand.Parameters.Add(paramTemp); paramTemp.ParameterName = "@pLoginEmailAddress"; paramTemp.Value = companyName; paramTemp.DbType = DbType.String; sqlCommand.Parameters.Add(paramTemp); paramTemp.ParameterName = "@pTelephone"; paramTemp.Value = companyName; paramTemp.DbType = DbType.String; sqlCommand.Parameters.Add(paramTemp); paramTemp.ParameterName = "@pPassword"; paramTemp.Value = companyName; paramTemp.DbType = DbType.String; sqlCommand.Parameters.Add(paramTemp); int affectedRows = SqlDataManager.ExecuteNonQuery(sqlCommand); return(true); }
public void Execute() { // Fluent interface - Stored Procedure with parameter // -------------------------------------------------- var manager = new SqlDataManager("DefaultDatabase"); // DefaultDatabase = connection string key // Map to collection of Model IEnumerable <Person> persons = manager .CreateCommand("spGetPersonsList") .AddParameter("@DepartmentID", 1) .IsStoredProcedure() .Fetch <Person>(); // Map to Model Person person = manager .CreateCommand("spGetPersonsList") .AddParameter("@DepartmentID", 1) .IsStoredProcedure() .Fetch <Person>() .Single(); // To Data Table DataTable dataTable = manager .CreateCommand("spGetPersonsList") .AddParameter("@DepartmentID", 1) .IsStoredProcedure() .FetchAsDataTable(); // DataTable to Model var collection = dataTable.As <Person>(); // SQL query as command text // ------------------------- IEnumerable <Person> personsTwo = manager .CreateCommand("SELECT * FROM Persons") .Fetch <Person>(); // Execute Non-Query //------------------ var result = manager .CreateCommand("spInsertPerson") .IsStoredProcedure() .AddParameter("@FirstName", "John") .AddParameter("@LastName", "Doe") .AddParameter("@Address", "Washington") .AddOutputParameter("@Status", SqlDbType.Int) .Execute(); // Non-fluent interface // -------------------- var command = manager.CreateCommand("spInsertPerson"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlDataQueryParameter("@FirstName", "John")); command.Parameters.Add(new SqlDataQueryParameter("@LastName", "Doe")); command.Parameters.Add(new SqlDataQueryParameter("@Address", "Washington")); command.Parameters.Add(new SqlDataQueryParameter("@Status", true, SqlDbType.Int)); var resultTwo = command.Execute(); }