Dave Noderer's Blog

South Florida does .NET!

  Home  |   Contact  |   Syndication    |   Login
  182 Posts | 0 Stories | 367 Comments | 28 Trackbacks

News

Twitter












Article Categories

Archives

Post Categories

Image Galleries

.NET Community

Life at the Beach

My Blog Friends

Friday, August 20, 2010 #

On Tuesday August 18th, the first publicly available beta for the Microsoft Lightswitch development tool was posted on MSDN.

For more information about this Silverlight application generator addition to Visual Studio 2010 visit: http://msdn.microsoft.com/en-us/lightswitch/default.aspx

Because it is still a beta I installed the 500mb ISO on a Windows 7 virtual pc VM which already had Visual Studio 2010. I had not spun up this VM for over 4 months so there were LOTS of updates to apply first. Although some have reported problems, mine went smoothly.

The default 512mb memory on the VM was not enough. Understandably it was very slow and when I first tried to run the generated program it timed out. So I increased the VM to 2gig and it ran much better!

For consultant time keeping, I’ve been using a classic asp website and access admin program for over 10 years. I could never justify making a change (nobody is paying for it).

I created a new Lightswitch project, both VB and C# are available:

image

I created a new datasource pointing to a SQL 2k5 server (2k5 or above is required) at my web host (http://www.Appliedi.net) where the Computer Ways timesheet data resides. Knowing that Lightswitch is based on Entity Framework and also that I’ve been meaning to do it, I added foreign key relationships on the main tables I would need. In the past this was enforced by the application originally on Access then SQL 7.

This process of adding a datasource is easy and familiar. It starts the datasource wizard:

image 

and ending up in the table / view selections for Entity Framework:

image 

Next I added a new “Screen” which brought up the data model, defaulting to Consultant but I switched to default of TimeSheetDetail by double clicking on it. This switched the view to what you see below by using the navigation on the objects which in turn is based on the foreign keys.

image

From here I could click on screen and decide on a format to display the data. I selected editable grid:

image

Running the project (no code at all so far), the program comes right up

image

I was able to actually add some hours for the day. Baked in is the relationships so selecting a consultant, for example, brings up this screen:

image

For many corporate and personal applications, this will be a great help. Unlike Access, this is .net in Visual Studio with a number of extension points.

This default screen can be customized in many ways, here is the “Customize Screen” view:

image

I have not deployed this but you get the option of web or client (it is Silverlight).

I’ll definitely expand on this over time and can see lots of applications.


Monday, August 16, 2010 #

I recently read the book “C# 4.0” How-To by Ben Watson, published by SAMS, ISBN-13: 978-0-672-33063-6.

I’m a primarily VB.net developer (hey I”m a VB MVP) but these days I find myself using C# more and more.

This is a practical book; seeing exactly how to code various patterns in C# was very useful.

The usefulness was three fold.

First, as C# is not my 1st language, sometimes I stumble a bit when trying to express some code in C#. There are many many examples of using a very wide range of classes that makes it easy to find a relevant case.

The second useful thing was just seeing a number of patterns programmed that I have not used myself. One area is implementing interfaces. It is a common practice in .net but there are lots of interfaces in the .net framework which I rarely touch. I liked the example of implementing a generic interface.

The third thing is seeing details of many .net class overloads expanded out in written form.  Although Visual Studio intellisense is very good, I must admit that even some of the string and numeric methods have overloads or options that I was not aware of.

I’m going to keep this one on my shelf for a while. I can see it as being very helpful when refactoring a troublesome piece of code!


Tuesday, August 03, 2010 #

After a few years of development, Microsoft has finally announced Lightswitch. This was formally a very hush hush project code named Kitty Hawk that even the MVP’s only had very limited knowledge of.

You can get more information at: http://www.microsoft.com/visualstudio/en-us/lightswitch and it will be generally available in Beta form on August 23rd.

This tool is an add-on to Visual Studio 2010 that allows a power business user (or developer) to very quickly generate a data centric application then make it into a client or web based application.

The resulting program is basically a Silverlight application.

Being all .net it is fully extendable in a number of ways but it will take a while for all those details to come out and I’m sure will change over the first few releases. One example is that Infragistics will have “skins” for it.

Jason Zander does a walkthrough on his blog at: http://blogs.msdn.com/b/jasonz/archive/2010/08/03/introducing-microsoft-visual-studio-lightswitch.aspx

Time will tell but I for one am excited to see the entry level programming made so much easier. People have compared this with Access which drove (and still does) many thousands of businesses but many of these “applications” had serious problems in the way they were structured and used. A vocal contingent “users” will create monstrosities with Lightswtich and then dump it on the professional programmers to straighten out as was the case with Access.

While there is some truth to this, and I created or touched hundreds of Access programs myself, I think the net result of making tools accessible to non-programmers is a very good thing. At least it forced the potential customer to think through what data they need and what screens they require in a way that is not possible without actually having a proto-type. The problem, as always, is when the proto-type turns into wide scale production.

In any case I’m in for the ride!


Saturday, June 26, 2010 #

Just a reminder to tune in all weekend, here is the published schedule:

http://www.dotnetrocks.com/liveweekend.aspx

Twitter Hash Tag: #dnrlive

Saturday, June 26
Time Content
8am-9am Patrick Hynds
9am-10am Michele Leroux Bustamante
10am-11am Rob Howard
11am-12pm Stephen Toub
12pm-1pm Music, Comedy
1pm-2pm James Kovacs
2pm-3pm Don Demsak
3pm-4pm Daniel Egan
4pm-5pm Brian Randell
5pm-6pm Tim Huckaby
6pm-7pm Chris Sells
7pm-8pm Music, Comedy
8pm-9pm Daniel Simmons
9pm-10pm Brian Noyes
10pm-11pm Patrick Hynds (Repeat)
11pm-12am Michele Leroux Bustamante (Repeat)

Sunday, June 27
Time Content
12am-1am Rob Howard (Repeat)
1am-2am Stephen Toub (Repeat)
2am-3am James Kovacs (Repeat)
3am-4am Don Demsak (Repeat)
4am-5am Daniel Egan (Repeat)
5am-6am Brian Randell (Repeat)
6am-7am Tim Huckaby (Repeat)
7am-8am Chris Sells (Repeat)
8am-9am Carl and Richard
9am-10am Charles Petzold
10am-11am Sahil Malik
11am-12pm Mark Dunn
12pm-1pm Music, Comedy
1pm-2pm Andrew Brust
2pm-3pm Glenn Block
3pm-4pm Ethan Winer
4pm-5pm Mary Jo Foley
5pm-6pm Kent Alstad
6pm-7pm Keith Elder
7pm-8pm Music, Comedy
8pm-9pm Mark Miller
9pm-10pm John Bristowe
10pm-11pm Daniel Simmons (Repeat)
11pm-12am Brian Noyes (Repeat)

Monday, June 28
Time Content
12am-1am Carl and Richard (Repeat)
1am-2am Charles Petzold (Repeat)
2am-3am Sahil Malik (Repeat)
3am-4am Mark Dunn (Repeat)
4am-5am Andrew Brust (Repeat)
5am-6am Glenn Block (Repeat)
6am-7am Ethan Winer (Repeat)
7am-8am Mary Jo Foley (Repeat)
8am-9am Kent Alstad (Repeat)
9am-10am Jonathan Zuck
10am-11am Jeffrey Palermo
11am-12pm Steve Evans
12pm-1pm Music, Comedy
1pm-2pm Scott Stanfield
2pm-3pm Ted Neward
3pm-4pm Tim Heuer
4pm-5pm Miguel Castro
5pm-6pm Les Pinter
6pm-7pm Billy Hollis
7pm-8pm Music, Comedy
8pm-9pm Rocky Lhotka
9pm-9:30pm Shootin the Breeze with Richard
9:30pm-12am Solvo (Carl's Band) Live!

Tuesday, June 29
Time Content
12am-1am Keith Elder (Repeat)
1am-2am Mark Miller (Repeat)
2am-3am John Bristowe (Repeat)
3am-4am Jonathan Zuck (Repeat)
4am-5am Jeffrey Palermo (Repeat)
5am-6am Steve Evans (Repeat)
6am-7am Scott Stanfield (Repeat)
7am-8am Ted Neward (Repeat)
8am-9am Tim Heuer (Repeat)
9am-10am Miguel Castro (Repeat)
10am-11am Les Pinter (Repeat)
11am-12pm Billy Hollis (Repeat)
12pm-1pm Rocky Lhotka (Repeat)
3pm-6pm


Saturday, May 15, 2010 #

Ok, honestly, I’m posting this so I can find it when I need it but Visual Studio 2010 uses a new report viewer that is compatible with .net 4.0.

http://www.microsoft.com/downloads/details.aspx?familyid=A941C6B2-64DD-4D03-9CA7-4017A0D164FD&displaylang=en

Bill McCarthy has some complaints (and a work around): http://msmvps.com/blogs/bill/archive/2010/04/19/upgrading-report-applications-to-4-0.aspx


Thursday, May 13, 2010 #

Good to see that government is getting more responsive to current technology.

This is a good article by Vivek Kundra, US Chief Information Officer and some examples of how the government is using cloud services.

http://www.whitehouse.gov/blog/2010/05/13/moving-cloud


Tuesday, May 11, 2010 #

I’ve been working a lot with Microsoft CRM over the past few months and much of the screen level customization uses javascript.

One thing I discovered today while breaking apart some dates was that the javascript getDate() returns the day of the month 1-31 as you would expect but the getMonth() returns 0-11… definitely not what I expected!!


Friday, May 07, 2010 #

I’ve been working with a program Scribe, similar in function to SSIS although I’m still an SSIS fanboy!!

The main feature my customer has Scribe for is to load data into Microsoft CRM 4.0.

A lot of what I’ve been doing is loading campaigns into CRM which are staged in SQL Server but I need to mark each one as imported so it will not get imported again.

The screen shot below shows how to setup the Source update. One important thing is that the source SQL table has to have a primary key defined (this was a staging table and I did not do that at first)

 

image


Monday, May 03, 2010 #

Found an interesting thing that others have run across but it is the first time I’ve seen it.

A customer emailed to say that the SQL 2008 db that I had helped him with seemed to be going into recovery mode on a regular basis while watching the SQL Management Studio screen.

Needless to say he was a bit nervous and about to take some drastic steps. Eventually he found that the Auto Close option was set to true.

When this is set to true, the database automatically closes all connections and unlocks the mdf file after 300 milliseconds. When a new connection is made it spins backup… Great for xcopy deployment on a client machine but not a multi-user server based application.

So the warning… if you have started a database with SQL express and then move it to a production SQL server, make sure you check that the Auto Close option is set to false.

See options screen below:

image


Saturday, April 17, 2010 #

This week Scott Cate came to South Florida and gave a great talk on his Visual Studio shortcuts and how he uses them. You can find a collection of short video’s he has done at: http://scottcate.com/tricks/

Also you might want to check out Sara Ford’s blog: http://blogs.msdn.com/saraford/default.aspx, she started doing a tip a day but has many more now. Scott covers many of these in the videos.

And.. as with past releases, the languages team has provided PDF’s with a lot of keyboard shortcuts, this time for VB, C#, F# and C++. You can find downloads for all of these at the top of the FlaDotNet.com page and are included below:

VB: http://www.fladotnet.com/downloads/VS2010VB.pdf

C#: http://www.fladotnet.com/downloads/VS2010CSharp.pdf

F#: http://www.fladotnet.com/downloads/VS2010FSharp.pdf

C++: http://www.fladotnet.com/downloads/VS2010CPP.pdf

Chris Catto adds that Zain Naboulsi has good tips too: http://blogs.msdn.com/zainnab

Happy Keyboarding!!


Friday, March 05, 2010 #

Catching up after our sixth code camp here in the Ft Lauderdale, FL area. Website at: http://www.fladotnet.com/codecamp.

For the 5th time, DeVry University hosted the event which makes everything else really easy!

Statistics from 2010 South Florida Code Camp:

  • 848 registered (we use Microsoft Group Events)
  • ~ 600 attended (516 took name badges)
  • 64 speakers (including speaker idol)
  • 72 sessions
  • 12 parallel tracks
  • Food
    • 400 waters
    • 600 sodas
    • 900 cups of coffee (it was cold!)
    • 200 pounds of ice
    • 200 pizza's
    • 10 large salad trays
    • 900 mouse pads

Photos on facebook

Dave Noderer: http://www.facebook.com/home.php#!/album.php?aid=190812&id=693530361

Joe Healy: http://www.facebook.com/devfish?ref=mf#!/album.php?aid=202787&id=720054950

Will Strohl:http://www.facebook.com/home.php#!/album.php?aid=2045553&id=1046966128&ref=mf

Veronica Gonzalez: http://www.facebook.com/home.php#!/album.php?aid=150954&id=672439484

Florida Speaker Idol

One of the sessions at code camp was the South Florida Regional speaker idol competition. After user group level competitions there are five competitors. I acted as MC and score keeper while Ed Hill, Bob O’Connell, John Dunagan and Shervin Shakibi were judges. This statewide competition is being run by Roy Lawsen in Lakeland and the winner, Jeff Truman from Naples will move on to the state finals to be held at the Orlando Code Camp on 3/27/2010: http://www.orlandocodecamp.com/. Each speaker has 10 minutes.

The participants were:

Alex Koval
Jeff Truman
Jared Nielsen
Chris Catto
Venkat Narayanasamy

They all did a great job and I’m working with each to make sure they don’t stop there and start speaking at meetings.

Thanks to everyone involved!

Volunteers

As always events like this don’t happen without a lot of help! The key people were:

Ed Hill, Bob O’Connell – DeVry

For the months leading up to the event, Ed collects all of the swag, books, etc and stores them. He holds meeting with various DeVry departments to coordinate the day, he works with the students in the days  before code camp to stuff bags, print signs, arrange tables and visit BJ’s for our supplies (I go and pay but have a small car!). And of course the day of the event he is there at 5:30 am!!

We took two SUV’s to BJ’s, i was really worried that the 36 cases of water were going to break his rear axle! He also helps with the students and works very hard before and after the event.

Rainer Haberman – Speakers and Volunteer of the Year

Rainer has helped over the past couple of years but this time he took full control of arranging the tracks. I did some preliminary work solicitation speakers but he took over all communications after that. We have tried various organizations around speakers, chair per track, central team but having someone paying attention to the details is definitely the way to go! This was the first year I did not have to jump in at the last minute and re-arrange everything. There were lots of kudo’s from the speakers too saying they felt it was more organized than they have experienced in the past from any code camp. Thanks Rainer!

Ray Alamonte – Book Swap

We saw the idea of a book swap from the Alabama Code Camp and thought we would give it a try. Ray jumped in and took control. The idea was to get people to bring their old technical books to swap or for others to buy. You got a ticket for each book you brought that you could then turn in to buy another book. If you did not have a ticket you could buy a book for $1. Net proceeds were $153 which I rounded up and donated to the Red Cross. There is plenty going on in Haiti and Chile! I don’t think we really got a count of how many books came in. I many cases the books barely hit the table before being picked up again. At the end we were left with a dozen books which we donated to the DeVry library. A great success we will definitely do again!

Jace Weiss / Ratchelen Hut – Coffee and Snacks

Wow, this was an eye opener. In past years a few of us would struggle to give some attention to coffee, snacks, etc. But it was always tenuous and always ended up running out of coffee. In the past we have tried buying Dunkin Donuts coffee, renting urns, borrowing urns, etc. This year I actually purchased 2 – 100 cup Westbend commercial brewers plus a couple of small urns (30 and 60 cup we used for decaf). We got them both started early (although i forgot to push the on button on one!) and primed it with 10 boxes of Joe from Dunkin. then Jace and Rachelen took over.. once a batch was brewed they would refill the boxes, keep the area clean and at one point were filling cups. We never ran out of coffee and served a few hundred more than last  year. We did look but next year I’ll get a large insulated (like gatorade) dispensing container. It all went very smoothly and having help focused on that one area was a big win. Thanks Jace and Rachelen!

Ken & Shirley Golding / Roberta Barbosa – Registration

Ken & Shirley showed up and took over registration. This year we printed small name tags for everyone registered which was great because it is much easier to remember someone’s name when they are labeled! In any case it went the smoothest it has ever gone. All three were actively pulling people through the registration, answering questions, directing them to bags and information very quickly. I did not see that there was too big a line at any time. Thanks!!

Scott Katarincic / Vishal Shukla – Website

For the 3rd?? year in a row, Scott was in charge of the website starting in August or September when I start on code camp. He handles all the requests, makes changes to the site and admin. I think two years ago he wrote all the backend administration and tunes it and the website a bit but things are pretty stable. The only thing I do is put up the sponsors. It is a big pressure off of me!! Thanks Scott! Vishal jumped into the web end this year and created a new Silverlight agenda page to replace the old ajax page. We will continue to enhance this but it is definitely a good step forward! Thanks!

Alex Funkhouser – T-shirts/Mouse pads/tables/sponsors

Alex helps in many areas. He helps me bring in sponsors and handles all the logistics for t-shirts, sponsor tables and this year the mouse pads. He is also a key person to help promote the event as well not to mention the after after party which I did not attend and don’t want to know much about!

Students

There were a number of student volunteers but don’t have all of their names. But thanks to them, they stuffed bags, patrolled pizza and helped with moving things around.

Sponsors

We had a bunch of great sponsors which allowed us to feed people and give a way a lot of great swag.

Our major sponsors of DeVry, Microsoft (both DPE and UGSS), Infragistics, Telerik, SQL Share (End to End, SQL Saturdays), and Interclick are very much appreciated.

The other sponsors Applied Innovations (also supply code camp hosting), Ultimate Software (a great local SW company), Linxter (reliable cloud messaging we are lucky to have here!), Mediascend (a media startup), SoftwareFX (another local SW company we are happy to have back participating in CC), CozyRoc (if you do SSIS, check them out), Arrow Design (local DNN and Silverlight experts),Boxes and Arrows (a local SW consulting company) and Robert Half.

One thing we did this year besides a t-shirt was a mouse pad. I like it because it will be around for a long time on many desks. After much investigation and years of using mouse pad’s I’ve determined that the 1/8” fabric top is the best and that is what we got!

MousePad2010 

So now I get a break for a few months before starting again!


Tuesday, December 29, 2009 #

Recently I had a need to create a SQL Server 2008 SSIS package that could do SFTP transfers. The FTP component that comes with SSIS is very useful but it cannot do secure transfers.

In the past I have had to use scripting to create dynamic script files for WS_FTP pro (which I do use and like very much!!) but this brought in many more moving parts and was subject to failure for a number of reasons.

After a bit of searching I found http://www.cozyroc.com and in particular the SFTP component: http://www.cozyroc.com/ssis/sftp-task.

Due to the fair amount of complexity in the file names on both sides I was driving it from a script task.

The programming is slightly different from the normal ftp task and actually a bit simpler. The normal examples for using the ftp task did not work with cozyroc and after a fair amount of experimentation and searching I finally submitted a question to cozyrock.

Ivan Peev (Mr CozyRoc himself) responded with a sample script: http://www.cozyroc.com/script/ftp-file-exists-task that quickly showed me how to accomplish what I wanted!

The component is happily transferring files securely in the automated process and I know I will be referring CozyRoc to customers when this need arises.

This is only one of the many components in the CozyRoc package. There are also control flow tasks for zip, ssh, amazon s3 and stream objects and data flow for oracle, informix, db2, edi and sales force to name a few.


Thursday, September 24, 2009 #

I'm at the Windows 7 launch event in Ft. Lauderdale working the community booth with Alex Funkhouser, Kathy Malone and a brief celebrity appearance by Shervin Shakibi,

Here are some pictures I took this morning!


Monday, September 21, 2009 #

I just got done reading "Effective REST Services via .NET" by Kenn Scribner and Scott Seely. ISBN-13: 978-0-321-6125-7

I've been hearing a lot about restful services and have absorbed the basics by osmosis but always like to read a book to cement the ideas more clearly.

This book does a good job of that but goes a few steps further.

A few things I particularly liked were:

- Review of http and how the internet works, things I don't pay much attention to any more!

- While presenting "pure" restful services also pointing out practical applications that might divert a bit.

- This book has a very good tutorial on asynchronous programming.

- The examples are good if a bit complicated but do build on each other.

- Senarios and examples cross both windows and web development.

- All in C# but was easy enough to read it looks like C# only books are the future.

It was worth the read and I have a much better understanding of restful services.


Tuesday, July 07, 2009 #

We had a great time at Brus tonight. 25 people showed up for the event and I got to clean out my prize closet with a raffle.

A few people made good job connections and I personally got to meet a few new people and find out what they are doing!

Thanks to Kaplan for sponsoring the appetizers!

 

\DSCN1410

 

DSCN1411

 DSCN1412

 DSCN1413

 DSCN1414