SharePoint 2016 Forms Technology

I have seen a couple of customers and partners wanting to know, what the future of forms technology holds in SharePoint 2016?

I have been search the web for any links or articles and I have managed to find a few useful links.One thing is for sure, there is no definite answer to this question. This has an impact on business and partners that have made (huge)investments into forms technology in the past.

Here are a list of links:

So what are the alternatives? What other great forms technology exists that one could use?

Sure, for new projects one can use AngularJS or web part development. However mentioning web part development and infopath in the same sentence do make some SharePoint Consultants cringe.

Visual Studio 2012

I had an interesting discussion regarding why some software engineers love / hate visual studio 2012; For me personnally this is a love/hate relationship with any software product. I have noticed people going on about what they hate.

Don’t we all hate change. It is the only constant in life. The more dramatic the change is, the steeper the learning curve.

With Visual Studio 2012 the best feature is the the layout and theme support.
It lags on the performance side when debugging applications, especially web applications.
I ue SQL management Studio alot, but can’t figure out why Microsoft has not decided to use a VS Studio as a base for all their applications. Now we sit with BIDS, SSMS and VS on one machine, developing a DB-centric solution. Why 3 tools Microsoft, why?

Then there are the features that we’re simply left out, like Data Compare and Software & Deployment features that worked great on VS 2010.

It would be very interesting to see what would happen, if eclipse would incorporate MVC or HTML 5 / JS development templates with C#? That would rattle the cage a little bit one would think;
It only can get better if you ask me.

Entity Framework and SQL Server 2008 R2 Replication

I am building a Application(C#) with a SQL Database to store my Data. This data is replicated to a Data Warehouse using SQL Merge Replication.I designed the database first, and setup the replication, and tested the replication using standard t-sql scripts in SSMS.

I then build the Application and decided to use the Entity Framework with the Database-First capability;

When I do an Insert, I recieve the following error: Column MyTable.rowguid in table MyTable must be mapped: It has no default value and is not nullable;

After spending some time on google I found a simple solution here.

Solution:

Open the Model, select the Entity Property, in my case “rowguid”

Model after Updated from Database

In the Properties, select the StoreGeneratedPattern and change it from None to Identity

Model after rowguid's StoreGeneratedPattern has been changed

 

 

Visual Studio 2010 Package Load Errors : Database Professionals Sql Server Data-tier Application

I had to remove SQL Server 2008 R2 and reinstall the Developer Edition. In the process, I managed to remove the Database Component for Visual Studio 2010…don’t ask why!!

After the reinstall I tried opening my Solutions, I got the following error messages when Visual Studio 2010 was launched: The ‘RadLangSvc.Package, RadLangSvc.VS, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd8080cc91′ failed to load VSTS for Database Professionals Sql Server Data-tier Application did not load and some other VSTS packages that was unable to load.

I followed the steps described here and here, and it worked .

The steps are also described below:

  1. Close all running instances of Visual Studio 2010
  2. Install the following MSI packages from the installation CD of VS2010, in the folder \WCU\DAC
    • DACProjectSystemSetup_enu.msi
    • TSqlLanguageService_enu.msi
    • DACFramework_enu.msi

Auto generate SQL Server UPDATE triggers for data auditing

You have a new requirement that all data changes to your tables need to be audited, so the old value is stored whenever a change is made.  One way of doing this is to create audit tables for each of the tables that you need to audit and write to these audit tables when data in the main table has changed. These triggers can be created manually one by one, but in this tip I show you how you can automate the creation of the triggers for each of the tables you need to audit by using a script to generate scripts.

In this tip we will go over creating UPDATE triggers for tables that need to be audited.

For More detail, read the complete article here;