Blog Home  Home Feed your aggregator (RSS 2.0)  
Joël Hébert | Opulent ASP - Tuesday, May 06, 2008
Enterprise ASP.NET
 
 Tuesday, May 06, 2008
Some of the members of the Ottawa .Net community were asking me to post the tools that I utilized during my N-layering presentation therefore I would like to bring them forth to my bloggers since they are superb
 
 First and foremost here is the stored procedure wrapper that creates a nice strongly-typed class to wrap your stored procedures...great time saver!
 
Stored procedure wrapper

 

Secondly  , here is the code generator I demo-ed.

Data Access Layer | Entity Layer | SQL Stored Procedure Generator Using Visual Studio 2005 & C#       

This Tool Generates Data Access Layer including respective stored procedures, associated Business layer and Entity layer class which is shared between both Data Access layer and Business Layer. It takes MSSQL connection string as input.

About C# Source Code Generator :
This Tool Generates Data Access Layer including respective stored procedures, associated Business layer
and Entity layer class which is shared between both Data Access layer and Business Layer.
It takes MSSQL connection string as input.

Benefits of using code generator:
1) Rapid Application Development. Saves lots of time.
2) It Uses Microsoft Application block which are optimised to transact with any database server with very less code.
3) All code is generated according to Microsoft coding standards.
4) No need to write stored procedures it generates for you.
5) Code is maintainable and standard

Prerequisite to Generate classes
.NET Framework 2.0,Microsoft Application blocks

Prerequisite to Use classes
Visual Studio 2005 ,Microsoft Application blocks

Enter Connection string in Connection string text Box
2) Enter location path where you want to generated file to be saved
3) Enter the desired root Namespace for all of your classes for ex. you can provide your company name or a project name etc.
4) Click "Connect to database " Button
5) Select the tables from the list and click "Generate Code " Button it will generate and save all the files to the provided location

CsharpCodeGenerator.zip (18.58 KB)

 

Thirdly, the orm tool that I showed is built into vs2008. Look only for instructions on linq to classes and you are good to go.

Tuesday, May 06, 2008 1:21:46 PM (GMT Standard Time, UTC+00:00)  #      Tools  | 
 Friday, April 11, 2008

 

The ODNC Luncheon Seminar Series Presents

Effective N-Layering in ASP.NET

 

The Ottawa .NET Community is pleased to invite you to a luncheon presentation on "Effective N-Layering in ASP.NET".  This presentation will be of special interest to web Developers/Architects that want to enhance their Rapid Application Development skills. Pack your lunch and join us for this unique lunch and learn opportunity. To register, send an email request to events@OttawaCommunity.Net.

 

Effective N-Layering in ASP.NET

This presentation will focus on tools and techniques associated with the rapid development of ASP.NET applications. It will begin by introducing N-Layering basics as described in Martin Fowler book “Patterns of Enterprise Application Architecture” and it will then demonstrate the creation of an N-Layered ASP.Net application with specific focus on 3 real-world scenarios;

 

1.      ASP to ASP.NET migration where the client does not want the back end (Database) to change

2.      ASP.NET Spaghetti Code refactoring using the existing stored procedures

3.      ASP.NET's effective use of the ObjectDataSource or LINQ with the Microsoft Entity Framework

 

About our Speaker

Joël Hébert is the Director and Chief Architect at Opulent ASP Development Inc. where he works as a consultant specializing in ASP.NET Enterprise Architecture/Development. He has developed large-scale web applications and Computer Aided Audit Tools for CaseWare-IDEA and is currently working on federal government projects. Joel is a long standing member of the Ottawa .Net Community’s steering committee and has been involved in many of its projects including; the “The Developers” TV show, Inter-User Group Challenges, and a number of MCAD/MCTS study groups. . Joel is also responsible for introducing & hosting the Product Discovery Showcases at our events.

Friday, April 11, 2008 6:15:20 PM (GMT Standard Time, UTC+00:00)  #      Presentations  | 
 Saturday, April 05, 2008

ASP.Net Pipeline Extensibility : Http Modules, Http Handlers, IHttpHandlerFactory, IHttpAsyncHandler and HttpApplication
By Joël Hébert

The HTTP Pipeline can be extended in ASP.NET adding pre and post processing to incoming requests. This said there are multiple scenarios that can benefit from these processings. The presentation will include a real life HttpHandler scenario based on an "Ip Address Authentication Mechanism". The HttpHandler will handle multiple scenarios via the Factory pattern and will be fired asyncronously.

The presentation is for Intermediate to Advanced ASP.Net developers interested in tapping into the pileline's end points or starting points in order to: url rewrite, serve images, authenticate and authorize requests, capture errors and more.

Attending this presentation will ensure comprehension of: ASP.Net Pipeline Extensibility Options, Http Modules, Http Handlers, HttpApplication class, Key Interfaces for handlers ( IHttpHandlerFactory & IHttpAsyncHandler)

A demo of a HttpHandler will showcase:
-How to create Http Handlers that are Asyncronous and tied to the Factory pattern
-Utilizing a custom IP Class to verify ipranges
-The SqlCacheDependency in Sql Server 2000 and 2005
-How to add Session State support in a Httphandler

Joël Hébert is an Ottawa based consultant specializing in enterprise web application development. He has spent a major part of his career with CaseWare-IDEA Inc. and CaseWare International Inc. where he worked on large scale web applications and developed Computer Aided Audit Tools (CAAT). As an executive member of the Ottawa .Net Community, he has participated in “The Developers” TV show, was on the Inter User Group Challenge winning team, took part in a multitude of MCAD/MCTS study groups and introduced the Product Discovery Showcases for 2006/2007. When Joel is not coding he enjoys the works of Jean-Jacques Rousseau , Denis Diderot and Montesquieu.

Saturday, April 05, 2008 6:12:16 PM (GMT Standard Time, UTC+00:00)  #       | 
 Wednesday, February 06, 2008

Today I attended an event with the Ottawa .Net Community based on the Page Flow Application Block.

I reallly liked what I saw but had some questions after the meeting. For those with interest here are some really good links:

Web Client Guidance Community site

Web Client Software Factory

Software Factories

They answered my questions. I always believe that after an event you should actually try to do the stuff. For me anyhow if I go home and watch hockey I am not going to retain much. I always go home and take 2  to 3 hours and at least research a bit.

I will blog on my findings when I am done...I think this lab is going to be instrumental to the learning curve.

Do see -> Hands-on Labs for WCSF June 2007 Release

 

 

Wednesday, February 06, 2008 2:46:57 AM (GMT Standard Time, UTC+00:00)  #       | 
 Tuesday, June 26, 2007

2007-06-26 Season Wrap Up Minimize

The Ottawa .NET Community Presents

Dealing with Real World Development Challenges

This is it; the 2006/2007 Season Wrap Up. It’s been a great season and we’re finishing it off with a collection of application development “Problems and Solutions” and a bit of a “Social”. 5 of our community’s top Solution Architects are going to walk us through the key development challenge that they were faced with in the past year and how they went about resolving it. Christian Beauclair, our Microsoft Senior Developer Advisor, will be hosting this panel of presenters and will be adding his own unique perspective on each of the Challenges/Solutions being presented. Following the presentation, we will be serving some refreshments and enjoying each other’s company before breaking for the summer. Come join us for this home grown community exchange and learn how to deal with some very real.NET development challenges.

This is How We Did It

Challenge 1: Creating Video Tutorials for Web Applications (Peter Hall)
Given a choice, most users would rather watch an instructional video than wade through a pile of documentation. Unfortunately not all developers know how to create an instructional video and attach it to their web applications. In this presentation, Peter Hall is going to walk us through the creation of an instructional video using Camtasia and the Microsoft Media Encoder, and then he’s going to show us how to attach it to a web application.

Challenge 2: Working with Embedded Real-time .Net (Michael Cox)
Developing an efficient Windows GUI based Application with real-time constraints in minimal time and maximum flexibility is a major challenge. Michael Cox is going to show us how he used Asynchronous I/O, Threading, Generic Queues, and Properties for User/Applications settings to come up with a solution that worked for him.

Challenge 3: Model Driven Development via the Visual Studio 2005 Class Designer (Joel Hebert)
Developing applications that scale well, promote code re-use, and facilitate maintenance is not an easy thing to do. In this presentation, Joel Hebert is going to show us how to use the Visual Studio 2005 Class Designer to create classes and layers that avoid many common application pitfalls; he’s going to talk about N-Tier Vs N-Layer architecture and the misconceptions that surround them; and he’s going to show us the basic steps involved in creating an N-layer application.

Challenge 4: Imbedding .NET User Controls into an MFC application (Graham Ross)
How does a Company with an existing product based on MFC and C++ move forward in order to take advantage of features and third party components available in .NET? Graham Ross is going to show us how he used the managed extensions in C++ to imbed .NET user controls into an MFC application.

Challenge 5: Organizing Your Development Environment (Wesley MacDonald)
Application development projects are made up of numerous artifacts (SVCS, Bug Reports, Project Plans, Requirement Docs,…) and managing them can quickly turn into a nightmare. Wesley MacDonald is going to show us how he uses Visual Studio Team Foundation Server to provide his team with an integrated development environment wherein all artifacts are stored under one roof and easily reported on.

About Our Solution Architects

Michael Cox is an Ottawa based Software Architect specializing in embedded real-time systems. He has spent half his career on embedded real-time system development for Defense based display projects and the other half with telecommunications embedded real-time development. Throughout his career Michael has strived for excellence in software development processes and optimum utilization of COTS hardware and software for embedded and real-time applications. When he’s not working on code; Michael enjoys cycling, hiking, dragon boat racing, and spending quality time with his wife and two daughters.

Peter Hall is the founder and CTO of SiteBenefits, a company that delivers web solutions to the Restaurant Industry. Previous to SiteBenefits, Peter spent 10 years as a Technical Architect at EDC; Product Manager for Corel CD Creator; Account Manager at Software AG; and started his career as a Production Engineer at Dofasco.

Joël Hébert is an Ottawa based consultant specializing in enterprise web application development. He has spent a major part of his career with CaseWare-IDEA Inc. and CaseWare International Inc. where he worked on large scale web applications and developed Computer Aided Audit Tools (CAAT). As an executive member of the Ottawa .Net Community, he has participated in “The Developers” TV show, was on the Inter User Group Challenge winning team, took part in a multitude of MCAD/MCTS study groups and introduced the Product Discovery Showcases for 2006/2007. When Joel is not coding he enjoys the works of Jean-Jacques Rousseau , Denis Diderot and Montesquieu.

Wes MacDonald is a senior .NET Architect/Developer and the VP/CTO of MarketObject. Wes has been working with Team Foundation Server since its beta release and is currently helping government departments adopt it and the .NET 2.0 Framework as their primary development platform. In addition to his expert skills in .NET, Wes is well versed in Oracle, SQL Server, and J2EE. He is a well respected mentor and currently focuses much of his attention on web based e-Commerce applications, web administration applications, and Text searching applications via web services and the web.

Graham Ross has over 20 years of experience in the IT Industry. He has an in-depth knowledge of Microsoft .NET, COM, client server architecture, object oriented design and development. He has several years of experience developing scalable mission-critical desktop and server applications. His most recent experience was as lead architect for the development of a client-server product used by accounting firms for financial data analysis and fraud detection. As an executive member of the Ottawa .NET Community Graham has been involved in organizing and running community events, MCAD/MCSD study groups, and Inter User Group Challenges.

Event Details

This Event is Proudly Sponsored by

Date: Tuesday, June 26, 2007
Registration:  5:30 PM - 5:45 PM
Presentation: 5:45 PM - 8:15 PM
Wrap Up:        8:15 PM - 8:30 PM
Social:             8:30 PM - 9:30 PM

Refreshments: Food and Drink will be served
Location: Microsoft's Glacier Room,
                 100 Queen Street, Suite 500,
                World Exchange Plaza, Ottawa, Ontario

Register for this event via an email to Events@OttawaCommunity.NET

Tuesday, June 26, 2007 6:23:30 PM (GMT Standard Time, UTC+00:00)  #      Presentations  | 
 Thursday, November 16, 2006

We participated and took home the gold in the 2005 IUGC. We developed for 4 months an application that utilized Microsoft Enterprise Application blocks, Web Services, MapPoint, Windows Services, Mobile Apps, and more. We architected the product by using Use-Case Diagrams / Class Diagrams / UML. The theme was to develop an application that woul enable people to live healthier lives. Therefore we set to do so by creating an application that allows you to register/ plot a running course / allow others to subscribe via web or mobile app. MapPoint was used to plot the courses directly from the database.

Thursday, November 16, 2006 2:51:05 AM (GMT Standard Time, UTC+00:00)  #      Competitions  | 
Copyright © 2012 Opulent ASP Development Inc.. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.