Based on the 17/6/19 Dat 602 class.

Even though it’s possible to connect a database directly with the program. This is not recommended because I can create additional connect and compleicate the code. Other programer might find it hard to understand our coded if we use this method.

For our project we will use data bindings. Any object using Ilists in .net will be able to use databinding. Only one datasource for binding object.

We will create our own connections as .Net is not completely compatible with mySQL.

We need to create our own list from our datasource as they wont bind properly, as the datasource doesn’t return the correct information.

We must clear a datasousre before we call it.

Basie on the dat602 5/06/19 class.

Read umcommited means that if a query is reading data while another querry is changing the data, this allows us to avoid blocking.

Read commited allows the proceess to be blocked if another funtion is editing it.

Repeated read reads a funtion from when the select statement is run regardless of what the program is doing.

Selrialable means that the everything including select statement will corse the data they are working with to become locked.

In an uncommit means that we are seeing the data even though they are not commited yet so if they user doesn;t commit it the data we have read will be wrong.

Seliablizable will effect performances.

Recommended to talk about Issolation levels when we talk about ACID in our report.

Based on the 4/6/19 dat602 class.

Transnational sql is where any changes we make to our database will not be save until we commit the change. We started by turning auto commit of in sql.

We can use start translation to declare a part of code in which we can roll back if we wish.

Rollback can be used to undo any changes we make.

Transnational handlers can handle mistakes within sql. If the query finds an error then the program can use roll back to return to the position before changes began.

Roll back will return the database to the position before the translation happened this. THis include everything in the translation which is relevant if an error is the coarse of the rollback. If part of a translation is run and the next part coarse an error the first part is also returned to it’s original state.

Operational information is keeped out side of the database in it’s own scheme.

Atomicity is where the database will only do one thing at a tie where isolation is where the database tries to switch who is doing anyone thing at any time.

Delete has several way it can be implemented. Such as cascade which was mentioned in a previous blog. We may set the value to null with set null. We can also validate the deletion with restrict, which prevent a row form being deleted if another thing reefers to it.

These create table statement are added to the end of the delete statement. They also must be place near the end of the table with rows we want to delete.

We may also set up similar behavior for update statements.

To be able to pass things into SQL we need a list of parameters.

A connection string is a string which tells a program to connect to a specific database.

Based on the 28/5/19 dat602 class.

Functions can’t return values for a set. For our project we will need to find a way of working around this and tricking the program into be leaving that the the function is returning a single function.

Procedure can pretty much do anything so we don’t have to worry about this with them.

Procedure let us re use code and automate things. This will be useful in our project by allowing us to reuse parts of the program such as change a user statics or updating a pieces persecution.

Transitional squeal allows as to make a change to a database with out committing it, so we don’t have to worry about breaking the database. We must use commit to commit it and we can use rollback to go back to the prior state.

The default perameter in mySQL is IN so we must tell it that we want stuff to be passed out.

Made based on the 27/5/19 Dat602 class.

For milestone two we need to create SQL procedures and transaction for our game.

We must research ACID which is something I have never heard of so I must study this out of class.

We must create a test base base as well as a basic test class in visual studio to test all of the database.

Part of this assessment is to create a command line method to test every part of the database.

We may change parts of our plan if we find an area of our plane doesn’t work out.

A definer gives the function the administration rights of who ever creates the function not the person running.

Invoker has the program take the priority of the person running the function.

Invoker is safer than a definer because a definer can allow anyone to alter the database even if they don’t normally have those permissions, this could be bad with something like an SQL injection attack which could coarse irreversible damage to the database.

Out allows a procedure to pass a variable similar to how you would pass a variable by Ref in visual basic.Out parameters passes things out In has thing passed to it.

A cursor will allow us to move for a set based system to a row based system.