Duck -Day 3

Standard

You can’t get too complacent in this game, I had a terrible day today, I have created 1 entity model Entities.edmx generated from the SQL db and that had been fine all day.

Suddenly it stops working and I’m getting the error:

MetadataException: Unable to load the specified metadata resource

I tried deleting and recreating the edmx file, no change. Renaming it then changing the code, still nothing. I checked the connection string, it was creating and it looked fine:

connectionString=”metadata=res://*/Entities.csdl|res://*/Entities.ssdl|res://*/Entities.msl;provider=System.Data.SqlClient;provider connection string="data source=xxxx;initial catalog=ctl;multipleactiveresultsets=True;application name=EntityFramework"” providerName=”System.Data.EntityClient”

It wasn’t looking good, so off to Google and Stackoverflow et al. I eventually came across this:

http://stackoverflow.com/questions/689355/metadataexception-unable-to-load-the-specified-metadata-resource

The answer that worked for me was to simply enter the assemblyname to replace the * in the connection string I then deleted and regenerated the same name edmx file in the wizard and ignored the generated connection string, but I suspect it would of worked as is and was probably just superstitious at the time.

Not sure how the problem happened, it might of been when I was regenerating the entity model.

I used to delete the model and regenerate it after a significant amount of stored procedure changes have occurred, but from now on I will only do a refresh for table changes and remove and re-add stored procedures to get the latest ones. My previous method messed up TFS anyway.

Good to see the code working again… good night.

Duck Hunt – Day 2

Standard

Started putting the app. together, using code first even though I have some legacy SQL Server tables I’d like to include, lets do this right!

I’ve got a basic wish list of modules I think are essential to finish before I can get beta testers near the code:

Registration
Login and password management
Invoicing
Expenses
Customers
Timesheets
Projects

Sounds like a lot at the moment, but if I can get the bulk of it done it will have been worth it.

I’m not sure how much detail to put in here as I’ve no idea who my audience is or will be (or if there even is one) So apologies if this is too technical or not technical enough.

Duck Hunting

Standard

Ok, I’m not really hunting ducks!

Let me explain further, I am a developer and I’m about to undertake a 30 day experiment in order to fast forward the application I want to develop.

This application is called business duck (I know, sounds silly but please read on) It is a service that will help people manage their businesses and hopefully stay afloat during that all important first year.

I am a commercial freelance developer and when I’m working on contract for someone 9-5 I know a month goes by very quickly; but here I will not obey 9-5 and hopefully I’ll get a lot more done this way.

So I left the wife and kids, the cat and all the client work behind in London and moved up North to my Dad’s house for the next 30 days. I will try and get as much functionality working on Business Duck as possible; hence the title. I will be keeping a diary of how I get on here.

The tools

I will be building the app. with visual studio 2015, c#, MVC5, jQuery, Entity Framework 6 and SQL Server.