For those of you whom are attending DevTeach it will be fun to have a few chats and to greet each other once again. I wanted to let you guys know I will be attending this pre-conference session. I chose this topic due to two reasons. I have seen Adam Machanic speak in Ottawa and it was very well done. The eloquence and simplycity was bar none.
For a reference do peruse here:
Designing Highly Concurrent SQL Server Database Applications
Here is a little more about the session I am attending.
The integration of the Common Language Runtime into SQL Server 2008 provides SQL Server developers and DBA with a vast new toolset for solving complex business and technical problems. This full day post-con event is designed for SQL Server DBA and developers who know some .NET or .NET developers with a strong interest in databases, and is designed to take the attendee from SQLCLR beginner to expert. You will learn all of the ins and outs of working with SQLCLR routines, including best practices for leveraging them in real-world scenarios.
By Adam Machanic Pre-requirements: 300-level; assumes at least one year of basic SQL Server and .NET (C# preferred) experience
Here is a little more about Adam:
Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "Expert SQL Server 2005 Development" (Apress, 2007) and "Inside SQL Server 2005: Query Tuning and Optimization" (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP).
The ODNC Luncheon Seminar Series Presents
An Introduction to ASP.NET Dynamic Data |
| |
We’ve got a bit of a “good news, bad news” situation. The bad news is that we ran out of time at last week’s “Season Kick Off” and Joel Hebert (our ASP.NET MVP) was unable give his presentation on “ASP.NET Dynamic Data”. The good news is that he’s agreed to present this material at next week’s Luncheon Event! As always, these Lunch and Learn sessions are a great way to enhance your development skills and meet up with colleagues and enjoying your lunch all at the same time. If you’d like to join in then please RSVP for the event by sending an email request to events@OttawaCommunity.Net today!
An Introduction to ASP.NET Dynamic Data
ASP.NET Dynamic Data is a web application scaffolding framework from Microsoft that can be used to build data driven web applications. It is packaged as an extension to ASP.NET and can be easily incorporated into a development project. This presentation will describe some of Dynamic Data’s key attributes and some of the scenarios in which it can be put to good use. We will also look at the ease with which Dynamic Data applications can be customized to meet your specific requirements.
About our Speaker
Joël Hébert is a Microsoft MVP for ASP.NET and 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. |
The Ottawa .NET Community Presents
The 2008/2009 Season Kick-Off
| |
Greetings Everyone! The Labour Day Weekend is around the corner and it’s time to kick off another season of Presentations, Special Projects, and Study Groups aimed at helping you become the Developer Superstars that you were meant to be! On Thursday evening, September 4th, we’ll be hosting our first presentation of the season with 2 speakers and 3 topics. Joël Hébert and Wesley MacDonald will be talking about managing session state in a web farm environment, getting more out of your development efforts with SharePoint 2007, and the Dynamic Data Extension that comes with ASP.NET. We`ll also be talking about the year ahead so please do RSVP for this event by sending an email to Events@OttawaCommunity.Net ASAP! We look forward to seeing you soon…..
About Presentation #01
Topic 1: Effective Web Farm Session State Management
Presenter: Joël Hébert, Microsoft MVP (ASP.NET)
Handling ASP.NET session state effectively can become a challenge. There exist scalability, performance and architectural bottlenecks associated with the various options that are available. This said there are numerous techniques and topologies that have been developed for web garden and web farm scenarios. Determining which option is best for your environment is key as no one technique is better than another; rather it is simply best suited. In order to determine suitability we will converse and demonstrate the various elements of each option and showcase coding implementations.
Topic 2: DO LESS. GET MORE.
Presenter: Wes MacDonald, Microsoft MVP (Team System)
This presentation will look at SharePoint 2007 in terms of user management, web parts, page branding and workflows. It will show you why you should be developing your applications on SharePoint 2007 and what you’ll need to get started.
Topic 3: Introduction to ASP.NET Dynamic Data
Presenter: Joël Hébert, Microsoft MVP (ASP.NET)
ASP.NET Dynamic Data is a web application scaffolding framework from Microsoft that can be used to build data driven web applications. It is packaged as an extension to ASP.NET and can be easily incorporated into a development project. This presentation will describe some of Dynamic Data’s key attributes and some of the scenarios in which it can be put to good use. We will also look at the ease with which Dynamic Data applications can be customized to meet your specific requirements.
About our Speakers
Joël Hébert is a Microsoft MVP for ASP.NET and 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.
Wes MacDonald is a Microsoft MVP for Team System, a senior .NET Architect/Developer and a Principal Consultant for Like 10 Inc. Wes has been working with Team Foundation Server since its beta release and is currently helping government departments adopt it and the .NET 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 currently focused on SharePoint 2007, Hyper-V and Windows Server 2008. Learn more about Wes at http://wesmacdonald.spaces.live.com/. | |
Today, I got a very nice email, followed by me screaming like the kid in Home Alone, stating that I have received/have been awarded the Microsoft Most valuable Professional Award for ASP.NET.
I am very excited to become and MVP and extremely excited to extend my duties as an ASP.NET expert.
I met Justice Gray at the Microsoft Community Influencer Summit ... was perusing his blog and noticed he is reading 27 books in 27 weeks!
Inspired by this I went on chapter.ca (yes that is the canadian one, vive le syrop d'erable!) and puchased a set of books to read within the next year
Here are the books I am going to read in the next year:
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.
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.
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.
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.
|
Copyright © 2012 Opulent ASP Development Inc.. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
|
|