Are you or your developers writing stored procedures by hand? Are they creating duplicate CRUD (Create Read Update Delete) logic in multiple places? If so, you should consider a code generator.
Advantages of using a Code Generator
The benefits of using a code generator, such as the PDSA Haystack Code Generator to generate your data access logic are huge! If you are not using one, you need to ask yourself why? If the answer is because you think no one else can write code the way you can, that is not a good enough reason. When you consider how long it takes you to create, test and debug data access code, and how much time you put in when the schema of a table changes, you will soon find out that you are wasting a lot of time. The major reasons for using code generation are as follows:
- Generation of INSERT, UPDATE and DELETE statements
- Generation of stored procedures to do INSERT, UPDATE and DELETE
- Bullet proof code for doing the Create, Read, Update, Delete (CRUD) logic
- Ability to regenerate CRUD classes if schema changes
- Consistency of code from one application to another
- Moves SQL out of the UI tier and into a middle tier where it belongs
- Moves the dependence on a particular database provider out of the UI
- Reduces code complexity in the UI layer
- Ability to map columns to properties in a class
- Provide IntelliSense of tables, stored procedures, views and columns
- Provides strong-typing of data in one location
- Ability to customize templates to fit "your" style
- Abstracts and encapsulates all data access code
- Ability to separate programmers working on UI and data access
How to Pick a Code Generator
Before you start using a code generator you need to find one that allows you to do all of the things listed above. Be sure you can quickly and easily modify the code that is generated. In addition looks for one that supports generating multiple UI layers such as WPF, Angular, MVC, etc. The ability to generate a SOA layer such as Web API calls or WCF is an added bonus.
How you create your CRUD logic needs to be thought out just as much as how you design the rest of your application architecture. Making many small classes/methods and then combining those together produces much more robust and maintainable code. Sure you end up with more classes, but these can be move to other assemblies so you don’t have to see all those files. You will definitely benefit in the long run. Using a code generator can really help speed up the development and ensure quality when developing the CRUD logic for your database application.
There are several code generators available for you to use. PDSA has the Haystack Code Generator (www.pdsa.com/haystack). The Haystack Code Generator does support all of the items listed above including the ones listed in how to pick a code generator.
Visit www.pdsa.com/haystack to learn more about Haystack and to download a free trial version.
Click here to read a special report on what code generation can do for you.
Have you ever wondered if you and your team are creating applications in the most efficient manner? Would you like to be able to use the newest technologies, but don't know how to get there? If you answered yes to either of these questions, then it might be time to have a process and architecture review. What better person to perform that review than a professional Chief Technology Officer (CTO). PDSA has the right expert to help your team create a roadmap to move from point A to point B.
In IT, we need to keep our team growing, keep our processes up-to-date, and continue to use newer technology. All of this can be done while still getting your day-to-day jobs finished. Having a good technology roadmap in place, and getting senior management to buy in to that roadmap is essential. This roadmap covers both the process by which you develop software and your software architecture. If you are lacking such a roadmap in your organization, then it is hard to get senior management let you work on learning new technology and implementing that in your applications. The result of this is your development team feels antiquated, and if you are not careful, they will start looking for another job where they can be challenged and allowed to work with new technologies. If they do leave, you are left with downtime while you bring new people up-to-speed on your applications. In the long run this costs you way more than spending a little bit of time learning new technologies.
The job of a CTO is to assess the new technologies to determine which ones fit best in your software architecture. The CTO comes up with a roadmap on how to best learn and apply these new technologies. In addition, the CTO presents the plan to both developers and senior management to get a buy in from each. Finally, the implementation details are laid out and implemented. The end result is keeping management happy by the IT department delivering business value, and keeping the developers happy by learning new technologies. A win-win for all concerned.
PDSA can help you via our Virtual CTO program. We work with you to set a budget you can live with, and to meet the goals described in this blog post. Call us today at (714) 734-9792 and ask for Michael Krasowski or Paul D. Sheriff. We are happy to give you a complimentary assessment of your needs, and provide you with a proposal for our services.
Have you purchased a lot of off-the-shelf software? Do you use a few different cloud systems? Would you like to eliminate duplicate data entry? Would you like roll-up-reports across all of these different systems? If you answered yes to any of these questions, then PDSA can help you.
We have successfully integrated hundreds of systems over the years. Most cloud systems have an API layer that we can take advantage of to enter data programmatically, or extract data for you. We can take the data from one system and automatically post them to your other systems. This will save you a lot of time and money. Your employees will be much happier too as they won't get bored entering the same data over and over.
Call for Complimentary Assessment
Contact us at (888) 899-7372 or (714) 734-9795 and ask for Paul Sheriff or Michael Krasowski and we will give you a complimentary assessment of how we can integrate your software packages.
Does your IT organization have a Application Lifecycle Management (ALM) process written down and is it actually followed? How well are your processes working for your team? Are you delivering business value to your company? If you answered no to any of these questions, it is time for an IT Organizational Assessment.
There are over 9 areas that it is very important to look at to determine whether or not your IT organization is adding value to your company, or if it is just a cost center. You should look at how you take in work, how projects are developed and implemented, and how your organization is structured. All of these areas, and many more, should be part of a formal assessment process.
An assessment needs to capture the "as-is", what you want as the "future state" of your organization, and finally a well-defined "road map" of how you are going to get to that future state. It takes a seasoned professional to perform this assessment and guide your organization through the transistion. PDSA has the expert guides to assist you with this process. Our professional IT Organizational Assessment presents you with a set of findings, reasons, recommendations and remediation steps. We are here to assist you and your team become the best IT organization and add true value to your business. Contact PDSA, Inc. today to schedule a complimentary consultation where we can outline how we can assist your organization.
Many businesses overuse Excel in the operation of their company. This can be a big problem and should be avoided if possible. If you turn these spreadsheets into a web application you make it easier to keep your business running efficiently. Do you know the 5 major problems with running your business on Excel spreadsheets?
- Sharing spreadsheets leads to outdated information
- Can't guarantee someone won't accidentally delete an important number or formula
- Someone uses the spreadsheet incorrectly resulting in inaccurate results
- Hard to share among multiple offices
- Intellectual property in a spreadsheet can walk out your door
Call us today for a complimentary assessment of your Excel spreadsheets and see if it makes sense to convert them to a web application. Call Michael Krasowski at (714) 734-9792.
Paul Sheriff has just released an exciting new course called The Journey from MVC to Angular. Check it out at http://bit.ly/2a3wVNU
Do you want to learn how to move from MVC step-by-step to AngularJS? This course will show you how to do just that. Learn to slowly replace your Razor code with client-side code that is much more efficient. Moving to client-side can give you incredible performance gains on your web pages. If you have ever wanted to learn this exciting technology, now is the time with this new course.
Head on over to Pluralsight, sign up, and start watching the course today!
PDSA signs training agreement with a major aerospace firm. PDSA will conduct training courses for several programmers in OOP and WPF. We will assist them with moving some of their older technology into current state-of-the art WPF applications.
PDSA has assisted hundreds of companies and thousands of developers over the years to grow professionally. We use webcasts, seminars, workshops, conferences, mentoring, video, and on-site training courses. We focus on real-world solutions in our training so you leave knowing how to build solutions for your company. For more information visit http://bit.ly/2a7UQLw.
Is your boss asking you to make sure all your web applications look good on a mobile device? Is he looking for all his Key Performance Indicators (KPI) for his business to be displayed on his phone? If so, then you are ready to step up to HTML5, Angular, and Bootstrap. These technologies make it easy to create the responsive web application your boss wants. No need to create a native mobile app for applications like these. A mobile web application works just fine.
Like most technologies, there is a little bit of a learning curve, but that is where PDSA can help you. We have already built a ton of mobile web applications, so we can get your jumpstarted right away. Let us help you get started and you can work with us side-by-side so you learn the correct way to build responsive web applications.
Contact PDSA Today
For a complimentary assessment of your particular needs, call PDSA at (714) 734-9792 and ask for David Lefort or Michael Krasowski. We are happy to be of assistance.
If your application runs slow then your users and/or customers are unhappy. This will directly affect your bottom line. There are many reasons for performance bottlenecks. We have time-tested procedures to help you find these bottlenecks and resolve them.
Do you know the 59 areas that most affect your applications performance?
PDSA has a checklist of over 59 of the most common performance-robbing code in applications. We help you find these areas and give you recommendations for fixing each and every one. After our performance review we present back to you:
Findings: The bottlenecks found in your application.
Reasons: The reason why an item steals performance from your application.
Recommendations: Our recommendations describing steps needed to improve or correct your application.
Remediation: For an additional fee, PDSA can help you implement the recommendations.
Here is a very small sample of our checklist:
- Use Angular instead of Razor
- Inefficient SQL Queries
- Inappropriate use of Entity Framework
- Incorrect usage of ADO.NET
- Garbage collection usage
- Incorrect use of variables
- Method refactoring
We identify and find areas in your application where SQL may have been used inappropriately, or should have been used instead of code.
ADO.NET / Web API / Entity Framework
There are many ways to use ADO.NET, WCF Services, Web API, Entity Framework and other data access technologies. Choosing the most efficient method can greatly speed up your application. Our experts point out where improvement is needed in those areas.
Streamlining Method Calls
The correct use of methods in classes is vital for performance in your applications. Sometimes, just a little re-factoring of code can create a well-performing application.
Get a PDSA Performance Audit Today!
PDSA can give your application a professional performance audit and teach your programmers where to find performance bottlenecks. Contact us
today for a free consultation. Or call us at (714) 734-9792 and talk to David Lefort (ext. 222) or Michael Krasowski (ext. 223).
Where are my Savings?
Most people think you can save over 75% by developing applications offshore. The reality, as many studies have shown, is almost no savings at all. The savings of that low hourly rate are quickly eaten up in bad coding, not getting what you want, and your time managing those offshore people. This article explores the pitfalls of offshoring software development.
Be Careful What You Send Off Shore
Almost every article you read about companies sending projects offshore hoping to save money end up with higher costs than anticipated, missed milestones and inadequate quality. Add it all up and you are much better off doing your project here.
Read our special report entitled Offshore is not the Bargain You May Think