It’s pretty much the same as running a query. In your original code you are creating a command object, putting it in the cmd variable, and never use it. Here, however, you will use that instead of da.InsertCommand. Also, use a using for all disposable objects, so that you are sure that they are disposed … Read more
You have to call DataReader.Read to fetch the result: DataReader.Read() returns a bool indicating if there are more blocks of data to read, so if you have more than 1 result, you can do:
Because these two lines … … don’t take a parameter in the constructor, I guess that you create a context within the classes. When you load the city1… …you attach the city1 to the context in CityService. Later you add a city1 as a reference to the new Employee e1 and add e1 including this reference to city1 to the context in EmployeeService. As a result you have city1 attached to … Read more
That’s because the DataRowCollection class only implements the non-generic version of IEnumerable. So the compiler doesn’t know what the type of the variable is. By explicitly putting the type in there, you basically tell the compiler to generate an explicit cast from object to DataRow. This is a problem you’ll find with many of the collections and classes added back in … Read more