Development Notes

EF Notes:

Intro article on EF: http://www.code-magazine.com/article.aspx?quickid=0712042&page=1

Great article on EF:  Getting started with ADO.NET Entity Framework in .NET 3.5

Nice PDF cookbook on EF: EF Notes with PDF:  entity framework learning guide.zip (6.10 mb) and Code: EFLearningGuidecompleteproject.zip (7.34 mb)

EF Audit Trail: http://www.codeproject.com/KB/database/ImplAudingTrailUsingEFP1.aspx?display=Print

EF Tutorial: http://innocraft.spaces.live.com/?_c11_BlogPart_BlogPart=blogview&_c=BlogPart

Automatic Timestamp: http://rabblerule.blogspot.com/2008/10/automatic-timestamping-for-entity.html

FTF ODBC Notes:

DB2
dsn=DEV400;UID=NEW;PWD=NEW;
MAYTGDATA.SEEDTBL
UPDATE MAYTGDATA.SEEDTBL SET SEED_DESC = 'AmeriContracts' WHERE SEED_KEY = 37000

SQL Server
dsn=ACCENT_FTF;database=ACCENT_FTF;UID=ACCENT_FTF_Admin;PWD=youknow;

Links:

• Good SQL reference: http://www.w3schools.com/Sql/default.asp
• SQL Strings: http://www.sqlstrings.com/

jQuery

jQuery Grid:
http://www.trirand.com/blog/
http://trirand.com/jqgrid/jqgrid.html

jQuery with ASP.Net webmethod:
http://blog.runxc.com/post/2009/05/01/jQuery-with-AspNet-couldne28099t-get-any-easier.aspx

jQuery is every Asp.Net web applications best friend.  I am going to show you the easies way to interact with an Asp.Net page using JSON.  JSON (JavaScript Object Notation) allows you to pass objects between .Net and Javascript.   If you are using .Net 3.5 then you have JSON serialization of your objects on the .Net side covered.  If you are using a version of .Net prior to that I recommend you look at Json.net.

Calling the server from the clients page using jQuery with a great plug-in called jmsajax (jQuery Microsoft Ajax)

# $.jmsajax({  
#    type: "POST",  
#    url: "Default.aspx",  
#    method: "UpdateSomething",  
#    dataType: "msjson",  
#    data: {Id:"text", name: "someName"},  
#    success: function(result) {  
#     if(result.Error)  
#     {  
#         page.someDiv.html(result.Message);  
#     }  
#     else  
#     {  
#         page.otherDiv.html("Something Successfully Saved");  
#     }  
#    }  
# }); 

Jmsajax fixes some issues with using jQuery with Asp.net.  The most important issue to note is that it corrects an issue with passing dates back and forth between Asp.net and JavaScript

The Server Side Web Method used to create and return our POCO as JSON

   1.  [WebMethod(true)]  
   2. public static Result UpdateSomething(string Id, string name)  
   3. {  
   4.     Result result = new Result();  
   5.     result.Error = false;  
   6.     result.Message = "The Cost Per Unit must be filled out";  
   7.     return result;  
   8. }  

And there you go now you can call a method on the page behind from JavaScript.  Now go and add some Ajax functionality to your web sites.

Get the MS Ajax Plugin: http://schotime.net/jMsAjax.aspx

Interface elements http://interface.eyecon.ro/download
50 amazing jQuery examples: http://www.noupe.com/jquery/50-amazing-jquery-examples-part1.html

Nice Datapicker: http://jqueryui.com/demos/datepicker/

Heat color: http://www.jnathanson.com/blog/client/jquery/heatcolor/index.cfm

Test.