/// <summary> /// Use ObjectQuery to get SqlConnection and SqlCommand. /// </summary> public static void GetSqlCommand <TEntity>(IDbContextBase context, IQueryable query, ref SqlConnection connection, ref SqlCommand command) where TEntity : class { var queryobject = GetObjectQuery <TEntity>(context, query); if (queryobject == null) { throw new System.ArgumentException("Paramter cannot be null", "queryobject"); } if (connection == null) { connection = new SqlConnection(QueryExtension.GetConnectionString(queryobject)); } if (command == null) { command = new SqlCommand(QueryExtension.GetSqlString(queryobject), connection); // Add all the paramters used in query. foreach (ObjectParameter parameter in queryobject.Parameters) { command.Parameters.AddWithValue(parameter.Name, parameter.Value); } } }
/// <summary> /// Use ObjectQuery to get SqlConnection and SqlCommand. /// </summary> public static void GetSqlCommand(ObjectQuery query, ref SqlConnection connection, ref SqlCommand command) { if (query == null) { throw new System.ArgumentException("Paramter cannot be null", "query"); } if (connection == null) { connection = new SqlConnection(QueryExtension.GetConnectionString(query)); } if (command == null) { command = new SqlCommand(QueryExtension.GetSqlString(query), connection); // Add all the paramters used in query. foreach (ObjectParameter parameter in query.Parameters) { command.Parameters.AddWithValue(parameter.Name, parameter.Value); } } }