Entity Framework 5.0 for VB.Net – Good enough for me

July 10, 2014

Our soon to be open source CRM versino 5 is using the Entity Framework 5.0 for data connection. It is FAST, easy to wire up and has some amazing time saving features.  I have yet to find a data/webUI need yet that I cannot do with EF5 and MSSQL.  I am using more stored procs than ever, but the elegance of calling them with EF5 makes them a treat to use.  I used to not appreciate them, as I could do a lot in code, and never really ran out of or needed more resources.

Here  is a Step-By-Step of how I start my projects with VS2012/13 and EF5.

Part I

In VS >>File >> New Website -VB Template and an ASP.Net Empty Website

Choose and appropriate location to start (filesystem) – I like to have my sites start at D:\clients\<Client or Project Name>\wwwRoot\

start hereThis is a blank site so add an Images folder and a Data folder, and a default.aspx file to get started. In between the Div tags add “Hello World!” then hit F5 to see if the app compiles and runs.

You should see a localhost website run in your default browser with the words Hello World! in the top left.

If all is OK, proceed.

Part II

In VS >>Tools >> Library Package Manager >> Package Manager Console
Run >> install-package entityframework -version 5.0.0.0

If ok proceed.

Part III

This part makes the assumption you have a database ready to do some work in. If not please refer to my other tutorials to create the basic CRM application repository (MS SQL for me).

Right Click on the DATA folder >> Add >> Add New Item (CTRL-Shift-A) data

Choose ADO.Net Entity Data Model >> give it a useful name (CRM.edmx)

>> Generate From Database, then next

crmEntityCreate a new connection to your local (or web hosted) server, save the Connection String to the Database, and give the the entity connection a useful name such as crmEntites.

tables

Choose the tables you wish to connect to.  Give the model name a useful name: crmModel is what I use.

Ransems and Michael Gerber

July 6, 2014

Gerber and ransemsI have had the privilege to wok with a few great business minds throughout my short (so far) business career.  One of the best is Micheal Gerber.

View us chatting here: https://www.youtube.com/watch?v=iNFZl8KO8Zg

 

Simple Yet Elegant CRM

July 5, 2014

I started a new version of our own in-house CRM for Think Business Training and ITO Hosting using Visual Studio 2012/2013 and MS Azure cloud services, MS SQL 2012 and Visual Basic ASP.Net 4.5 focusing and using the Entity Framework 5.0.

We choose EF 5.0 because of it’s ability to use the visual tools when designing webpages with data connections, Saving us countless hours by easily dragging and dropping an EntityDataSource on a new webpage and choosing the connection, and wiring up a Details view or a GridView.

We purchased a skin to make it look pretty and it included some great functional design elements that make it look more professional than most of the commercial CRMs on the market.

We are now poised, after 3 or 4 implementations to take it to the world. I am going to chronicle our endeavor and the adventures we are on here in both business terms and technical terms.

An open letter to a report from NowOrNeverNS.ca

February 15, 2014

An open letter:

I just read the report, noworneverns.ca  while it is thorough and comprehensive, it is sometimes way off the mark. Innovation and job growth, expansion of our exports is all great, but one point makes me upset:

“universities and the Nova Scotia Community College as foundations for future economic growth in the province. The Commission believes there is even greater potential for these vitally important institutions to bring their immense institutional capacities to bear on the economic, social and cultural development needs of the province. In doing so, we believe the post-secondary” p59

Now or Never - the report

Now or Never – the report, my take on it

This is truly BS. They are not innovating (well, maybe very slowly?). They cannot be the drivers of growth. They are not the foundation either. From a basic Econ Courses we teach in first year business we know that high taxes, high gov’t involvement – does the exact opposite of growth and innovation. It is not the way. WTF?

If you talk to any of the private training and education companies around Halifax including mine: Think Business Training? you will find that we compete directly with the Provincial Goverment – giving away free skills training to businesses – because these skills were not taught in our schools. What a waste.

The local universities as well as the NS Community College all are attempting to get a bigger piece of the after Post Secondary market too. If you did not do a good enough job while you had the students paying for their education why do you think you can do a better job after they graduate and are at a workplace?

You (universities and NSCC) should take a look at the skills being taught, the curriculum of you programs, and provide the skills while they are in school. The waste is atrocious!

Most recently we found ourselves competing with the Halifax Chamber of Commerce. Through WIPSI  the Chamber has come up with the idea that they are providing a great service to their members by funneling these grants into the pockets of the very few service providers who are “friends” of the Chamber. I say friends, they really are “founding members” of the All Ships Rise program invented to take advantage of the WIPSI program funds.

Think Business Training

Think Business Training

What is actually happening is more of the same. Many people are being put into inappropriate programs, with no regard to their true needs for training, via these grants. The program is promoted as free training and the companies are taking advantage of it. Or are they being taken advantage of? While I agree that some free training is better than no training, I am not sure the money is being well spent.

When asked if the training is making a difference, the answer is “we do not know”. So another waste of time and money…hmmm…all the while they are taking the grant money off the table, and taking the training time away from companies who might be able to innovate, and grow and deliver an ROI for the training dollars.

Training can be an export business, it can create jobs, but not if the small business growth opportunities have to compete with the province and the provincially funded institutions. It’s just more of the same, lining the pockets of the few, and providing no ROI for the people it was designed to help. Nice try….

I see absolutely no innovation coming from these organizations. They are are using their resources (big budgets compared to most companies) to supply basic training to the people working in companies who were already “let down” with inadequate training and education while they were going through the very education system that the province supplied them with our tax payers money in the first place.

High school did not prepare them, a lot of the university and trade programs did not adequately prepare them. Why do you (Gov’t?, universities?, NSCC?, Chamber?) think you can do better? By taking the money out of the marketplace and continue to deliver the same training the same way we have been delivering education for the last 100 years.

As an active member of the business community I appreciate you getting all of our young people ready for a world that exists no longer.

I really appreciate competing with you in an industry that needs to change to be better, and compete globally.

Thank you for taking 80% of the market and put it back into the very system that sucks!

WTFx2

I Love Donald Trump

December 12, 2013

If there is one quote that I think about on a constant basis it is this one:

If you’re going to be thinking anyway, think Big!

Of course the reason why I think about this is two fold.

1. It’s a great inspirational quote from a man who has seen some downs (really low if you’ve read anything about him) as well as some highs.  I also like the Apprentice for so many reasons.

Think Big Trump Poster

Think Big Trump Poster

2. There is a poster next to my desk in my house that has it portrayed with a great kid.  This poster reeks of potential, as well as has a great big brand image front and center.

This lead to one more stray thought in a response to an email that I sent out today, which is the basis of this post.

If you’re going to fantasize anyway, why not fantasize the positive.  We all have the habit of making up stories in our head about people at work, most times not so much in a flattering light.

Our boss, our customers, our co-workers, etc.  What if all of the stories you made up in your head were positive instead of negative?  How would your work life be?  How would your life be?  Would you have more happiness?

Another way of putting it:

If you’re going to make shit up, why not make great shit up!

You can quote me on that.

Your Amygdala

December 10, 2013

Your amygdala controls a lot of what we do when we find we are facing the unknown. This was very useful 10,000 years ago.

We, in modern society now face a series of chemical (emotional) reactions deep within our body (brain) that serves us no longer.  Because they are deep we do not notice them as much as we should, and as such we react in ways that are counterproductive for business and society.  We are holding ourselves back and as such, holding back the progress of the whole human race.

Victor Frankl Toronto

Victor Frankl Toronto

If you can start to notice these things, and start to ignore them (it is a lot easier for some than others, and it is a lot easier as you do it more often) we can make huge strides in our goals and dreams – quicker than we ever imagined.  Having a great big “WHY” that is outside of yourself can also assist in making sure the intention is intact as you go through your day with the proper attention.

Executing on your “next most important thing” is the hall mark of success and ignoring the amygdala cocktails is a great way to see what’s on the other side of the part of life we call work.  For most the other side presents “great things” and then of course “more challenges”.

Victor Frankl points to another angle on this fact in his explanation of the theory of Crabbing to students in Toronto http://www.youtube.com/watch?v=fD1512_XJEw which I believe is so true.

I have extrapolated this a bit as part of a working thoery of business.  This might be a stretch for some to see the disparate connection but here goes:

“If you give people too much to do and help them focus upon the ‘next most important thing’, they will either learn to ignore their tendencies to do unimportant things, or they will leave – either way they will learn a lot about themselves.  Both may be very therapeutic for them, and beneficial for the business and challenges ahead.”

RA – Halifax, NS

Is your business looking to have interna

August 21, 2013

Is your business looking to have internal resources do some of the core training? We have a program for you: http://ow.ly/o7JTE

More than just using MS PowerPoint, it’

August 9, 2013

More than just using MS PowerPoint, it’s about how to design a presentation to engage the audience: http://ow.ly/nMZLf

What level is your organizational learni

August 2, 2013

What level is your organizational learning at? http://ow.ly/nyzz5 http://ow.ly/i/2LP0t

Google Analytics for Dot Net Nuke 7 (DNN7)

June 17, 2013

GoogleAnalytics

Login as your admin on your DNN7 web site.

From the menus >> Admin >> Advanced Settings >> Google Analytics

Add your UA tracking ID as seen here:

TrackingCode

Click the update button and wait for people to search, visit and get tracked.

I have been using DotNetNuke since version 4 and recently, with the release of version 6 and 7 have really come to appreciate the depth of the application as a platform for running the web side of your business.  For more information check out: http://www.dotnetnuke.com to download the free version, or visit my hosting website at http://www.ito.ca to get a quote and see what we can do for you.


Follow

Get every new post delivered to your Inbox.

Join 995 other followers