• C# Getting the Constant Value from Class using Reflection

    By on Wednesday, February 08, 2017 | Filed Under Software

    In C# Getting the Constant Value from Class using Reflection need not be a difficult and there are quite few articles and blogs written on the subject. I wanted to mimic the GetNameQuery function that is in Hibernate, maintaining backward compatibility while converting services to C# using Dapper. For Inspiration I looked at this blog. This returned a list of the constant Names and what I actually wanted to do was look through all the constant names and then match mine an...

  • Creating Dapper entities Using MSSQL

    By on Monday, February 06, 2017 | Filed Under Software

    Creating Dapper entities using MSSQL and Mapping classes is rather easy, but very time consuming from scratch. This came around because I really got tired of the typing a multitude of class and mapping files So let's jump into it. Firstly, lets go get the list of tables, this will return a list in the correct format for the T-SQL in clause. The reason why I did it this way was because it's easier to remove those that I don't want to generate entities for. DECLARE @d...

  • Dapper ORM to Easily Map Column Names

    By on Friday, February 03, 2017 | Filed Under Software

    This is just a short post in using Dapper ORM to Map column names in Mssql generating c# csharp code. I had a requirement using Dapper ORM to Easily Map Column Names, problem was that the columns names had Underscores in them and the need to Have uppercase letter at the beginning of each word to conform to naming conventions. The service we are re-writing has numerous mapping tables so it all started out fine doing the tables with only a few columns, but as things cot m...

  • Hackerrank – Weather Observation Station 4 – MsSql

    By on Thursday, August 04, 2016 | Filed Under Software

    Hackerrank - Weather Observation Station 4 I have always loved just killing some time on Hackerrank, doing some challenges. And today was no different, but what was funny about it was I got stumped by one of the stupidest and simplest things under the sun. I really believe in software we should always look for the simplest answer, but in my case I couldn't for the love of me come up with the simplest answer which is: SELECT COUNT(CITY) - COUNT (DISTINCT City) FROM STATI...

C# Getting the Constant Value from Class using Reflection »

By on Wednesday, February 08, 2017

In C# Getting the Constant Value from Class using Reflection need not be a difficult and there are quite few articles and blogs written on the subject. I wanted to mimic the Get...

Creating Dapper entities Using MSSQL »

By on Monday, February 06, 2017

Creating Dapper entities using MSSQL and Mapping classes is rather easy, but very time consuming from scratch. This came around because I really got tired of the typing a multit...

Dapper ORM to Easily Map Column Names »

By on Friday, February 03, 2017

This is just a short post in using Dapper ORM to Map column names in Mssql generating c# csharp code. I had a requirement using Dapper ORM to Easily Map Column Names, problem...

Okay, after choosing what plane you are molding, in this case the fuz came from a crashed Opus, donated to me by a friend. I Repaired best I could, sanded and resprayed the Fuselage with a 2K (2 part) primer and 2K paint, each time wetting it flat down to 1000 grain paper. The last layer of Purple was sanded down to 1500 grain. Each successive layer is wet sanded to provide a smooth and error free surface, eventually you will find a surface that is free from errors, cracks and dust. This is time consuming but well worth it in the end as 2k paints provide the perfect surface to polish to a mirror finish.

So while it’s not 100% completes as there is still a lot of Rust on the base of the De Walt radial arm Saw. There is still loads of fasteners that need to be re-blued due to Surface rust which I will fix with my Electrolytic rust Remover, I think it looks loads better then it did when it was purchased. I need to use the machine so it will need wait while I complete the houses pictures rails and Skirting boards. i have a long standing love for a De Walt radial arm Saw, and there are many article on this machine that say it dangerous and outdated etc… What they don’t tell you is 95% of the time it’s not set up correctly and that this machine is really a workshop powerhouse. I suppose that’s why De Walt called this radial arm Saw DW-1251 “Powershop”. Anyways, enough on that here is the before pictures and then an after picture.
 De Walt radial arm Saw DW-1251 Powershop before restoration

De Walt radial arm Saw DW-1251 Powershop before restoration

De Walt radial arm Saw DW-1251 Powershop before restoration

De Walt radial arm Saw DW-1251 Powershop before restoration

The Machine before restoration

the Saw before restoration

The De Walt radial arm Saw DW-1251 Powershop After some restoration

We all face the problem of rust somewhere along the line and the question is how to remove it or even recover some of the metal without doing any damage to the actual part itself

Electrolytic rust removal or Electrolysis

DO NOT USE STAINLESS STEEL or CHROME, The process breaks down the sacrificial anode and deposits Chromium in the water and the will end up in the local water so don’t do it, and it consider Hazardous Material. Also Hexavalent Chromium cause birth deformities etc so it’s nasty. The process also lets off Poisonous gases so JUST DON’T do it. Also putting some other Chemicals in the process will also perform electro plating for you but more about that in another build maybe. The process can also perform Electropolishing using Salt and propylene glycol (aka Anti-freeze), once again more about this LATER, and they are both more complicated.

Read Full Article

This post contains pictures from around the internet of Aircraft I have built, either for myself or for others. As time goes on and I find more I will add them here

Something I always forget is when you just want to test a connection or create a connection string, there is this awesome little trick which is part of Microsoft Data Access Components (MDAC) on Windows 2000 and above. The Universal Data Link or UDL (.udl) File. To create the file is as easy as right clicking on the desktop or in a Windows Explorer window and clicking on create New text Document. Right Click on the file again, rename the extension to .udl. Ignore the warning that is shown ” A warning that changing file extensions can cause files to become unusable might appear.”

Read Full Article

We always in inevitability end up with duplicates data where we don’t need it. This is a simple way to find and remove those duplicates. I have documented this procedure for MSSQL 2008 up. Email me if you want the same type of procedure for Databases where you cannot run a CTE (common Table expression).

Finding the duplicates
The first hurdle to success is to find the columns that we can use to determine whether the duplicate exists, this is don’t by writing a query to verify the duplicate Data exists, without that then this is almost a pointless task. In my case It was with a customer Table (Table and Column obfuscated names obviously). Numerous customers had value had duplicate ProfileKey’s, whilst this is only an idea it was critical to avoid duplicates in many systems such as billing and customer management systems.

Read Full Article

Composite molds

Making a composite mold is all about preparation,like anything else if the foundation is good you have a good start. Mold making for a composite aircraft is no different, see what materials are available ask questions and try it. Composite materials vary and it’s always best to find the right stuff for the job.

I constantly strive to find new ways of doing things and over the years I have found some things work better than others. This time round I need to thank Mike (aka mikegbogh) for the recommendation of using a Farecla product called G6 Regular Grade Paste Compound. I contacted the local Agent, and they gave me some samples to try needless to say, two days later I bought the products, Wow!!!!. This product is available from most good Automotive paint store, if you are stuck try the Local Agent Gondolier they have a list of distributors per region. Internationally you will need to go to Farecla Products/ and track down a distributor.

Read Full Article
Page 2 of 41234