Lance Larsen – .NET Architect Madison Wisconsin

Oct

Remapping MySQL Workbench “Execute SQL” to F5

Categories: Code, SQL

As a primarily Microsoft SQL Server developer, when playing around with MySQL database ( specifically using MySQL Workbench ) wanted to be able to press F5 to execute the SQL commands that I was writing, by default you need to press Control-Enter or Control-Shift-Enter – but there is no GUI interface to remap keys shortcuts like there is in most Microsoft programs… so… found that the following worked and wanted to share!

Locate your “main_menu.xml” MySQL configuration file – mine was in “C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6\data\main_menu.xml”. Find the following XML.

   1:  <value type="object" struct-name="app.MenuItem" id="com.mysql.wb.menu.query.execute_current_statementwin">

   2:    <link type="object" key="owner" struct-name="app.MenuItem">com.mysql.wb.menu.query</link>

   3:    <value type="string" key="caption">Execute Current Statement</value>

   4:    <value type="string" key="name">query.execute_current_statement</value>

   5:    <value type="string" key="command">builtin:query.execute_current_statement</value>

   6:    <value type="string" key="itemType">action</value>

   7:    <value type="string" key="shortcut">Modifier+Return</value>

   8:    <value type="string" key="platform">windows</value>

   9:  </value>

Replace the “shortcut” xml (line 7 above) with the following, exit and reopen MySQL Workbench – and you’re rocking with F5!

<value type="string" key="shortcut">F5</value>

Sep

momentjs + UTC date/time = browser local time

Categories: Code, JavaScript, Web

Comments: No

You should almost always store your date/times in your database as UTC – you may think it’s not important now, but as soon as your application needs to display times to users in different time zones ( to paraphrase Yoda ) …it will be, it will be…

But do you need to know and store your user’s timezone to display it correctly?

Nope, JavaScript and momentjs to the rescue…! :)

Sep

jQuery 1.x && 2.x + MVC script bundling

Categories: .NET, Code, JavaScript, Web

Comments: No

In my blog “NuGet – Limiting updates for jQuery and Bootstrap” – we looked at continuing to utilize NuGet to keep us up to date on the latest jQuery 1.x version ( even though 2.x is out ). Reason being that we needed to stick with 1.x because we are still supporting IE 7/8. :(

So… jQuery 1.x and 2.x have feature parity – but you want to use jQuery 2.x when you can, simply because it’s a smaller download as they were able to take out a lot of IE7/8 “fixes”. Note, jQuery’s post on conditionally include one or the other based on the version of the browser.

But we also like to use the cool MVC bundling and minification feature – can we have the best of all worlds? Oh ya… :)

Sep

Entity Framework “Code First + Computed GETDATE()”

Categories: .NET, Code, Entity Framework

Comments: No

Need to setup a “Created” DateTime field in your SQL table that is auto-computed to add the current date and time that the field is inserted into the database?

If you’re doing so in SQL – in the “Default Value or Binding” you just need to enter GETDATE() or GETUTCDATE() – insert a record, and you’ll see the date/time value automatically added to that column. “…that was easy…”

But how to do the same thing when using Entity Framework Code First?

No big deal here either – as long as you add the couple lines of code described here…

Aug

NuGet – Limiting updates for jQuery and Bootstrap

Categories: .NET, Code, NuGet

Comments: No

I love to say “…if it’s not in NuGet, it’s DEAD to me…” – and for the most part that is very true. :)

If you don’t know what NuGet is – you MUST – look at Introducing NuGet: the smart way to bring bits into your projects

However, as I and many developers need to continue to support IE7/8 – we can’t update to the latest versions of jQuery or Bootstrap, as jQuery version 2.+ and Bootstrap version 3.+ no longer support IE7/8…

Also considering jQuery is continuing to update their 1.* version with updates – how do we handle that and continue to use NuGet inside of Visual Studio to show us when there are updates that we DO want to install?

Here’s the solution!

In your “packages.config” file – add the allowedVersions tag to both as follows ( noting that the right parenthesis looks strange, but it is correct – it means ‘less than version X’ )…

<package id="jQuery" version="1.10.2" allowedVersions="[1.9.1,2)" targetFramework="net45" />

<package id="bootstrap" version="2.3.1" allowedVersions="[2.3.1,3)" targetFramework="net45" />

Now when you open up NuGet ( noting that you need to close and reopen VS and the project ) – you see the following!

For this, we were on Bootstrap 2.3.1 – and only saw an upgrade to 3.0 – but now we see we can upgrade to the latest 2.3.2! And we’re currently at the latest jQuery 1.10.2 – so correctly don’t see an update – but we will when one comes out. :)

I love NuGet… :)

Aug

ROBOTS ROBOTS ROBOTS! Lego Mindstorm EV3

Categories: Presentations, thatConference

Comments: No

Are you are new to robotics? Or do you go to bed dreaming of counting cybernetic-sheep? In either case, Lego Mindstorms EV3 has just released an awesome next generation robot kit that’s made for everyone! EV3 adds never before seen functionality in a format accessible to all current and future programmers. Learn how to start teaching and showing others how to use the Lego programming tools! And just have fun with Robots! :)

PowerPoint presentation from ThatConference 2013 (Big 109MB!)

Check out the EV3 Core Set on Lego Education US!

May

Share your “That Conference” Schedule!

Categories: Events, thatConference

Comments: No

Some very difficult choices in choosing from so many awesome talks at That Conference – but can’t wait – and wanted to share…

For those speakers and talks that I’m not able to get to – love to have you out to MADdotNET to give your presentations!

Encourage everyone to share their schedule!

Monday	8:30 AM	Denise Jacobs	Denise Jacobs Keynote
	10:30 AM	Chris May	Developing applications for Google Glass
	1:00 PM		THAT Wildlife
	2:30 PM	Chris Gardner	Biometrics: Using You Body for Fun and Profit
	4:00 PM	Mike Rohde	Sketchnoting Workshop
	8:00 PM		Game Night
Tuesday	8:30 AM	Dave Thomas	Dave Thomas Keynote
	10:30 AM	Leon Gersing	Keep Software Weird
	1:00 PM	Lance Larsen	Sewing for Geeks — IL Weaving with AOP
	2:30 PM	Brian Kalbfleisch	We Can with WeDO. Using LEGO to Teach Little Campers Programming.
	4:00 PM	Lance Larsen	Robots Robots Robots! Lego Mindstorm EV3
	5:30 PM		That Pig Roast
	10:30 PM		Waterpark Party
Wednesday	8:30 AM	Doc Norton	Michael “Doc” Norton Keynote
	10:30 AM	Sharon Cichelli	Hello, Arduino: Write code that interacts with the real world
	1:00 PM	Keith Burnell	Teaching the Junior Campers to Program with the Grown Up Tools
	2:30 PM	John Hauck	Kidz That Code

May

That Conference Xbox’ish “Achievements" for All!

Categories: Events, thatConference

Comments: 2

Created the following Xbox’ish Achievements and wanted to share with everyone for That Conference!

Updated my Counselor image on my That Conference Profile page as follows.

Download them all here! With a PaintShop Pro master image file for all the layer’y goodness.

Thanks Clark adding to the ideas!

May

thatConference 2013 Tickets on sale TOMORROW 8:12 am!

Categories: Events, thatConference

Comments: No

Tickets for #thatConference – the premier Mid-West ( and beyond ) developer conference go on sale at 8:12 am tomorrow morning!

Get over to Eventbrite early @ http://thatconference2013.eventbrite.com/

After all the success last year and 750+ very happy attendees – be warned that they could sell quickly, so get your tickets as soon as possible – don’t be left out of the waterpark… errr… developer conference…!

125+ talks — in fact, just finished arranging the schedule of talks ( top secret – hush hush ) – and there are so many great ones that I don’t know which ones to choose myself!
All technology stacks – and spectacular lineup of speakers. Check out the sessions! Check out the speakers! After that, easy decision…
New this year! A whole room and set of talks specifically for kids and family geek events — including many about teaching programming to kids. I’ll be doing “Robots Robots Robots! Lego Mindstorm EV3” about the not even released yet new LEGO robotics Mindstorm EV3 set – that comes out just a little more than a week prior to the event. Look at these links for new EV3 awesomeness – http://goo.gl/HWgxz & http://goo.gl/5Qo0n
Waterpark – Waterpark – Waterpark! Did I mention I’m bringing my family to a developer conference? How many conferences can you say that about and NOT be filing for a divorce afterwards…? :)
Lastly, don’t forget to signup for the thatConference Newsletter – middle of page off of thatConference site.

Again – get on early – get your tickets and then you don’t have to worry about missing out.

See you at 8:12 am @ http://thatconference2013.eventbrite.com/

May

Custom Configuration Pattern 102

Categories: .NET, Code

Comments: No

So we will pick up from where we left off in “Custom Configuration Pattern 101” – we are looking to elegantly consume complex configuration settings in App.config and Web.config files – in this case we are looking to step up our game and consume the following…

<CertificateSection authenticationMode="Test">

  <Certificates>

    <add certificateType="cipherCertificate"

          findValue="E86D56AC84D51F9C2D12C898341F5FA38E909B02"

          storeLocation="LocalMachine"

          storeName="TrustedPeople"

          x509FindType="FindByThumbprint"/>

    <add certificateType="serviceCertificate"

          findValue="3D25DB176A2098F010C288761F5B367F3DFA07FA"

          storeLocation="LocalMachine"

          storeName="TrustedPeople"

          x509FindType="FindByThumbprint"/>

  </Certificates>

</CertificateSection>

We will continue our “CustomConfigurationPattern” console application!

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this: