edit-task

Task Name:

Task Description:

TaskGroup ID:

Start Date:

Start Time:

Duration:

Priority:

Status:

Add Photo:

Owner ID:

Content: use HTML Edit Content

<h1 style="text-align: center;">DATA - option 1</h1>
<h2 style="text-align: center;">connecting to a mySql database</h2>
<h2>[previously - how to article]</h2>
<ol>
<li>[00:00] CREATE new project</li>
<ol>
<li>] or use an existing project</li>
</ol>
<li>[00:00] Open Web.Config for the project</li>
<ol>
<li>] and include the <code>ConnectionStrings</code> after configuration/appsettings just before system.web</li>
<li>x] ADDed NEW conn string for your db (ex&nbsp;sospep public * NOTE sql provider )</li>
</ol>
<li>[00:00] create a view -</li>
<ol>
<li>x] for displaying the model, remember @model statement = yourProject.Models.Location</li>
</ol>
<li>[00:00] create a controller - </li>
<ol>
<li>x] passes the model data to the view</li>
<li>x] Location myLocation = new Location();</li>
<li>x] method Index(){return View(myLocation);}</li>
</ol>
<li>&gt;[00:00] create&nbsp;a model -</li>
<ol>
<li>] a class that contains all of the properties and methods of a given data entity, example Location</li>
<li>] uses db request(s) to populate instance of class</li>
<li>] need connection, command&nbsp;and reader objects to execute the command and process the returned data</li>
</ol>
<li>[00:00] ADD a REFERENCE to project</li>
<ol>
<li>x] REFERENCE = &nbsp;mysql (6.9.4), *] not listed, use search on mysql</li>
</ol>
<li>[00:00] ADD a using statement to /Controller</li>
<ol>
<li>x] using guideMVC.Models</li>
</ol>
<li>[00:00] PRB&nbsp;EDIT example GetConnection() method </li>
<ol>
<li>] SET connection name to mine, not example</li>
</ol>
<li>[****] SUCCESS</li>
<ol>
<li>] we are pulling a record from the designated db, returning it to a view and displaying to on the page</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>[00:00] NEW task IN</li>
<ol>
<li>x] DATA-decision -</li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li>] NEXT</li>
<ol>
<li>] multiple records</li>
<li>] connection object should be centralized</li>
</ol></ol>
&nbsp;
&nbsp;
<hr /><ol>
<li>[your DATA decision]</li>
<ol>
<li>] chances are your going to be working with some form of data and the need to persist(store) that data. There are a couple of main DATA&nbsp;scenarios to consider &nbsp;</li>
<li>] OPTION 1 - using an existing DB - commando - aka getting data out of and putting it back into an existing SQL database. &nbsp;</li>
<li>] OPTION 2 - using an existing DB wih EF db first -</li>
<li>] OPTION 3 - creating a new DB for the project using EF code first -</li>
</ol>
<li>]&nbsp;DATA OPTION 1 -&nbsp;asp.net MVC - connect to an existing db (mysql) </li>
<ol>
<li>] <a href="http://www.codeproject.com/Articles/822392/Connecting-to-MySQL-from-ASP-NET-MVC-using-Visual" target="_blank">http://www.codeproject.com/Articles/822392/Connecting-to-MySQL-from-ASP-NET-MVC-using-Visual</a>&nbsp;</li>
<li>] <a href="https://www.devart.com/dotconnect/mysql/articles/tutorial_ef.html" target="_blank">https://www.devart.com/dotconnect/mysql/articles/tutorial_ef.html</a>&nbsp;</li>
<li>] <a href="http://blog.jongallant.com/2013/04/mysql-aspnet-mvc-entity-framework.html">http://blog.jongallant.com/2013/04/mysql-aspnet-mvc-entity-framework.html</a>&nbsp;</li>
</ol>
<li>] DATA OPTION 2 </li>
<ol>
<li>]</li>
</ol>
<li>] DATA OPTION 3</li>
<ol>
<li>] <a href="http://www.asp.net/mvc/overview/getting-started/database-first-development/setting-up-database" target="_blank">http://www.asp.net/mvc/overview/getting-started/database-first-development/setting-up-database</a>&nbsp;</li>
<li>] <a href="http://www.asp.net/mvc/overview/getting-started/database-first-development/creating-the-web-application" target="_blank">http://www.asp.net/mvc/overview/getting-started/database-first-development/creating-the-web-application</a></li>
</ol></ol>
&nbsp;
<hr />
] tutorial - example
&gt;&nbsp;tutorial -&nbsp;<a href="http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio-mvc-project-wizard-usage.html">http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio-mvc-project-wizard-usage.html</a>&nbsp;
<a href="http://docs.oracle.com/cd/E17952_01/connector-net-en/connector-net-programming-mysqlcommand.html" target="_blank">http://docs.oracle.com/cd/E17952_01/connector-net-en/connector-net-programming-mysqlcommand.html</a>
<a href="https://msdn.microsoft.com/en-us/library/System.Data.SqlClient(v=vs.110).aspx">https://msdn.microsoft.com/en-us/library/System.Data.SqlClient(v=vs.110).aspx</a>&nbsp;
<a href="http://stackoverflow.com/questions/12181428/asp-net-mvc-4-ef5-with-mysql" target="_blank">http://stackoverflow.com/questions/12181428/asp-net-mvc-4-ef5-with-mysql</a>&nbsp;&nbsp;
<a href="http://stackoverflow.com/questions/2865454/can-we-build-asp-net-mvc-based-on-mysql-database" target="_blank">http://stackoverflow.com/questions/2865454/can-we-build-asp-net-mvc-based-on-mysql-database</a>
] docs - classes
<a href="https://msdn.microsoft.com/en-us/library/ms178359(v=vs.110).aspx">https://msdn.microsoft.com/en-us/library/ms178359(v=vs.110).aspx</a>&nbsp;- System.Data.SqlClient
<a href="https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand(v=vs.110).aspx" target="_blank">https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand(v=vs.110).aspx</a>&nbsp;- System.Data.SqlClient.SqlCommand
<a href="https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader(v=vs.110).aspx" target="_blank">https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader(v=vs.110).aspx</a>&nbsp;- sqlDataReader
<a href="https://msdn.microsoft.com/en-us/library/gg416515(v=vs.108">https://msdn.microsoft.com/en-us/library/gg416515(v=vs.108</a>) asp.net MVC 4
] g q = asp.net mvc mysql example
EF Reverse POCO generator
<a href="https://visualstudiogallery.msdn.microsoft.com/ee4fcff9-0c4c-4179-afd9-7a2fb90f5838?SRC=VSIDE">https://visualstudiogallery.msdn.microsoft.com/ee4fcff9-0c4c-4179-afd9-7a2fb90f5838?SRC=VSIDE</a>&nbsp;- generate classes from db tables
] mysql wizard VS&nbsp;-mysql + VS&nbsp;
<a href="https://www.youtube.com/watch?v=EulQWH3Z9AU" target="_blank">https://www.youtube.com/watch?v=EulQWH3Z9AU</a>&nbsp;
&nbsp;<a href="https://blogs.oracle.com/MySqlOnWindows/entry/howto_using_mysql_for_visual" target="_blank">https://blogs.oracle.com/MySqlOnWindows/entry/howto_using_mysql_for_visual</a>&nbsp;
&nbsp;
&nbsp;