This is a quick note on how to convert your LINQ Objects to JSON String. I had some issues doing so when only using the LINQ Class but did a quick fix by creating my own class and setting it up with the same information as the LINQ Object.

(more…)

Many real-world applications interacting with the SQL server use stored procedures, which are compiled by the database in advanced of execution which offer better performance over normal SQL statements, which are compiled when called.

They are secure, because it only needs to make calls to the database and use its stored procedures, rather than having some malicious user use your connection and could delete data. Stored Procedures can also take data input via parameters.

I’m a big fan of Stored Procedures, it just makes it allot easier for me to code between my C# classes to SQL separately.

(more…)

Very important note on how to connect to a SQL Database in Visual Studio 2008. The first interesting steps here is that, we can use C# classes to connect to our database and get data to and from it, via the class to our website.

(more…)

Working forward with connecting Oracle database with java and viewing the content. This is just basic connection.

(more…)

Make a simple database, Im using MAMP, its great. Get it from here.

The abbreviation MAMP stands for: Macintosh, Apache, Mysql and PHP. With just a few mouse-clicks, you can install Apache, PHP and MySQL for Mac OS X!

MAMP installs a local server environment in a matter of seconds on your Mac OS X computer, be it PowerBook or iMac. Like similar packages from the Windows- and Linux-world, MAMP comes free of charge.

Im going to add very simple sql “asking” “methods”. in the future, I will add notes on how to connect Flash, PHP and JAVA to the MYSQL Tables.

(more…)