Different ways to work with SharePoint Lists in Visual Studio 2013 LightSwitch
When you have SharePoint Enabled in a LightSwitch solution you can work with SharePoint Lists in different ways. As a data source or ‘in App’ added as a list to the SharePoint project.
The choice is yours what to use … below some different characteristics.
As a data source
adding a SharePoint List as a data source.
- The list must exist on SharePoint.
- The list isn’t deployed together with the LightSwitch App. There is no connection with the LightSwitch Solution and the SharePoint List only by connection string.
- When you upgrade your LightSwitch solution you must not forget to update your list manually (when you made table changes)
- The SharePoint list isn’t affected when you uninstall the App.
- The connection to the List is set during packaging of the App in Visual Studio When deploying the App to a different Site (where you created the list) , you must package the App specific for that site, with the proper connection string.
- The SharePoint Lists can be saved as STP, which can contain data.
- The SharePoint List is a LightSwitch entity, which can used by the screens. Browse Edit Add for free,
- The SharePoint List is an entity in the LightSwitch App and can be accessed in code with intellisense.
- You can create relationship between the different data sources.
As a List in the SharePoint Project
Add a List to SharePoint Project in the solution.
- Lists in the SharePoint Project uses the SharePoint App Deploy and Update mechanism. The table stays with the LightSwitch App, also when installed on different sites. When updating the table structure is updated too (when not deleting columns or changing data types, adding columns is fine). When deleting the App the list and data are gone too.
- The SharePoint List can be accessed with CSOM from LightSwitch.
- The table entities are accessed in code by Name, no intellisense and compile time warnings.
- The SharePoint List isn’t an LightSwitch entity ad can’t be used (out of the box / browse, update, edit for free) with the LightSwitch screens.
So the tradeoff is most about … the usages of the screens (browse, update, edit for free and intellisense ) versus the deployment model (a package per site and manual update the lists.)
2013 Application Lifecycle Management Partner of the Year.
Microsoft has a global award granted to Sogeti for Application Lifecycle Management (ALM). Sogeti has received this award for its active contribution to the development of the Microsoft ALM platform, a complete set of tools for developing, testing and managing software.
Toine on stage …
You can watch the full video from the WPC opening keynote here…
With four other awards Sogeti got during the ceremony in July, 2013 in Houston in the U.S it is the most awarded Microsoft partner. The five awards are part of the 44 awards that Microsoft gives to technology partners.
“Sogeti is sincerely appreciative of the recognition we have received from Microsoft in each of these categories. It has been an exciting journey to witness the evolution of the relationship between Sogeti and Microsoft. Our shared alignment and collaboration with Microsoft consistently provides the highest possible value for both our consultants and clients. These awards help to validate Sogeti, and our solutions, as some of the best among the Microsoft Partner ecosystem.” said Sanjeev Agarwal, Senior Vice President of Sogeti’s Microsoft Alliance.
Awards were presented in 44 categories, with winners chosen from a set of more than 3,000 entrants from 106 different countries worldwide.
Visit http://www.microsoft.com/en-us/news/Press/2013/May13/05-20WPC13PR.aspx for an overview of the awards Microsoft reaches during the Worldwide Partner Conference in Houston in the US.
visit http://www.sogeti.com/microsoft for our Microsoft alliance page.
Windows 8.1 camera feature: Photosynth
Just installed the windows 8.1 preview on my Surface RT … it is a must when you have a RT, really brings some additional value. one of these features is the Photosynth integration.
while it is always a kind of odd and funny when you see people taking pictures with the (low quality) tablets, the Photosynth features makes it really a nice activity.
The Photosynth button.
two view modes … use your finger
and tile mode viewing (move your tablet around)
really nice… and don’t laugh at me when I’m taking standing with my surface above my head.
side tip: you can take screenshots with a RT device by pressing windows key (on the device) and the volume key together.
Small Microsoft Test Manager Exploratory Test Tip for WinRT Apps: Action Log Sliced
A small but useful Microsoft Test Manager feature when executing an exploratory test on WinRT apps: Sliced Action Log.
As an addition to the steps to reproduce, you can look at the sliced action log to investigate the bug.
The extended action log can be found in the links tab of the Bug.
The only property to set is the Diagnostic Adapter ‘Action log’.
Fast and Flexible.
Modern businesses need fast and flexible IT. Fast in the realization of systems to stay ahead of the competition. And flexible in the direction the system implementation goes to easily adopt innovations which can bring business benefit.
A good practice for software development to stay fast and flexible is to take as less as possible dependencies. The well-known SOLID principles are a good example of this low-dependency practice to stay flexible. <<read on at labs.sogeti.com>>
Visuals Studio 2013 feature: Scrollbar Map Mode with Preview
A nice little VS2013 feature which can make your live easier… Scroll Bars map mode with preview.
the C# editor isn’t the only one which has it.
8 / 8.1 Store Apps creation capabilities of Visual Studio 2012 and 2013 Preview
Good to know…
- Visual Studio 2012 on Windows 8 Platform –> 8 Store Apps creation capabilities
- Visual Studio 2012 on Windows 8.1 Platform –> 8 Store Apps creation capabilities
- Visual Studio 2013 Preview on Windows 8 Platform –> No Store Apps creation capabilities
- Visual Studio 2013 Preview on Windows 8.1 Platform –> 8.1 Store Apps creation capabilities *
- Visual Studio 2012 and Visual Studio 2013 Preview side by side on Windows 8.1 Platform –> 8 and 8.1 Store Apps creation capabilities *
* With VS2013 Professional, Premium and Ultimate you can open and edit 8.0 Store Apps on Windows 8.1 Platform and retarget them to 8.1.
If you're opening your solution in Microsoft Visual Studio Express 2013 Preview for Windows, your solution won't load. In the next step, you'll retarget the projects in your solution.
If you're opening your solution in Microsoft Visual Studio Professional 2013 Preview, Microsoft Visual Studio Premium 2013 Preview, or Microsoft Visual Studio Ultimate 2013 Preview, your solution loads but still targets Windows 8.
Retarget your Windows Store app to Windows 8.1 Preview
* Install Visual Studio 2012 Update 3
Although team members work in the same room, still I see many collaboration challenges. Many team members need an extra motivation to start working together.
The Agile coach should explain and stimulate this.
Trust, courage, openes are good drivers to start with.
SkySight - a next generation cloud orchestration service
Capgemini announces SkySight - a next generation cloud orchestration service.
Capgemini, one of the world’s foremost providers of technology, consulting and outsourcing services, together with Sogeti, its local professional services unit, today announced a new cloud orchestration service called SkySight.
Developed with support from Microsoft Corp., SkySight will enable a wide variety of enterprises from multi-nationals to SMEs to integrate, configure, provision and manage cloud-based application workloads using a Capgemini-developed orchestration service.
Capgemini Announces SkySight - a Next Generation Cloud Orchestration Service
A Product Owner read up.
A small reading covering the role of the Product Owner in agile teams.
What does the theory says about the Product Owner’s role?
The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. How this is done may vary widely across organizations, Scrum Teams, and individuals.
The Product Owner is the sole person responsible for managing the Product Backlog. Product
Backlog management includes:
· Clearly expressing Product Backlog items;
- Ordering the items in the Product Backlog to best achieve goals and missions;
- Ensuring the value of the work the Development Team performs;
- Ensuring that the Product Backlog is visible, transparent, and clear to all, and shows what the Scrum Team will work on next; and,
- Ensuring the Development Team understands items in the Product Backlog to the level needed.
The Product Owner may do the above work, or have the Development Team do it. However, the Product Owner remains accountable.
The Product Owner is one person, not a committee. The Product Owner may represent the desires of a committee in the Product Backlog, but those wanting to change a backlog item’s priority must convince the Product Owner.
For the Product Owner to succeed, the entire organization must respect his or her decisions. The Product Owner’s decisions are visible in the content and ordering of the Product Backlog. No one is allowed to tell the Development Team to work from a different set of requirements, and the Development Team isn’t allowed to act on what anyone else says.
(Scrum guide | http://www.scrum.org/Scrum-Guides)
The primary goal of a product owner is to represent the needs and desires of the stakeholder community to an agile delivery team, being the first source of information about the problem domain for the team.
Each agile team, or in the case of large programmes an agile subteam, has a single product owner to go to for information and prioritization of their work and they do so right away.
A secondary goal for a product owner is to represent the work of the agile team to the stakeholder community. In traditional terms, a product owner is in many ways an empowered business analyst without the burden of the bureaucracy surrounding big requirements up front (BRUF).
The role of product owner was introduced to the agile community by Scrum, although the onsite customer practice of Extreme Programming (XP) is very similar. This role has been adopted by the Disciplined Agile Delivery (DAD) process framework.
(The Product Owner Role | http://www.agilemodeling.com/essays/productOwner.htm)
The product owner is commonly a lead user of the system or someone from marketing, product management, or anyone with a solid understanding of users, the market place, the competition, and of future trends for the domain or type of system being developed.
(Learning Scrum - The Product Owner | http://www.mountaingoatsoftware.com/scrum/product-owner)
How to recognize a good product owner?
Collaborate with the team on an ongoing basis and to guide and direct the team.
Empowered, and present.
(Being an Effective Product Owner | http://www.scrumalliance.org/articles/44-being-an-effective-product-owner)
Passionately about the customer of the product.
(Who Makes a Good Product Owner |http://geekswithblogs.net/rakker/archive/2010/05/17/who-makes-a-good-product-owner.aspx)
What are the needed capabilities for a Product Owner?
A good product owner is a good negotiator.
(Who Makes a Good Product Owner |http://geekswithblogs.net/rakker/archive/2010/05/17/who-makes-a-good-product-owner.aspx )
Understand the technical decisions
(Transitioning to Scrum: Selecting the Product Owner | http://www.construx.com/Retrospectives/Transitioning_to_Scrum__Selecting_the_Product_Owner )
A thorough understanding of the customer needs
(Being an Effective Product Owner | http://www.scrumalliance.org/articles/44-being-an-effective-product-owner )
(Skills a good Product Owner should Master | http://blogs.agilefaqs.com/2012/05/26/skills-a-good-product-owner-should-master )
Knows the organization.
(Qualities of a great product owner| http://www.scrum.nl/website/scrumblog.nsf/dx/7-qualities-of-a-great-product-owner )
How to recognize good work from a product owner?
The first artifact of an agile to look at when you want to know how they perform is the Backlog, and investigate if it is nice, clean and mature. If you want to know if the Product Owner is in trouble the backlog is also the place to look. Are there enough backlog items, are they well specified, are there acceptance tests etc …and are there backlog grooming sessions, with the product owner?
The goal of the UED (and anyone else involved at the time) is to add detail to the story in a just-in-time manner. There is usually no value to splitting a large user story up now or stapling a document to it if we won’t work on that product backlog item for quite awhile. While working to add detail in a just-in-time manner, those doing so should strive to add just-enough detail that no individual item will take more than one sprint to complete. Just-in-time and just-enough become the targets for establishing a smooth flow from product backlog to sprint backlog.
(Writing the Product Backlog Just Enough and Just In Time | http://www.scrumalliance.org/articles/87-writing-the-product-backlog-just-enough-and-just-in-time)
Sometimes called StoryTime sessions, the purpose of these meetings is to make improvements to the Product Backlog.
(How to Hold an Effective Backlog Grooming Session | http://www.scrumalliance.org/articles/339)
Grooming the product backlog should be a collaborative effort that involves the product owner and the development team
(GROOMING THE PRODUCT BACKLOG | http://www.romanpichler.com/blog/product-backlog/grooming-the-product-backlog/)
What are the challenges when mixing roles or transform a role to Product Owner?
It's important to understand that a piece of work can be done better by one whole person than by two half persons. Merging roles can lead us into strange situations. But Scrum guidelines clearly state that there are three roles: product owner, ScrumMaster, and development team. Scrum also demands 100 percent commitment from each of these roles. So if we merge roles, then it's simple: We aren't using Scrum. We should always mix our primary colors at 100 percent, rather than using uneven amounts of a variety of colors, to aim for white. We should not live with gray.
( Why Not Merge Roles in Scrum? | http://scrumalliance.org/articles/524-why-not-merge-roles-in-scrum )
Developer as Product Owner:
Developers like to develop features, technical challenging features. Beside that you see these challenging features bubbling up the backlog also the challenge will be the low level acceptance criteria, just due to the optimistic and code view of the developer.
Trigger: Technical Items on Backlog, Scope Creep.
Testers as Product Owner:
Testers can be good critics of the backlog quality. For example, questions will be asked if the backlog items are good written down and if they have good clear acceptance criteria. Beside the quality view also a good understanding of the product and users will make testers an interesting mix with the Product Owner role. A pitfall can be that too much design up front, will testers want to tackle most of the unknown upfront.
Trigger: big too detailed backlog.
Manager as Product Owner
It should be interesting to have your manager as a Product Owner. But for sure it wouldn’t be a good idea. Probably the knowledge of the product will be low. But more important the manager is your boss and when the boss wants something else you as a team member will probably listen although it is out of the sprint.
Trigger: interference in the sprints
Business Analyst as Product Owner:
You often see that analysts is the Product Owner or that they become the Product Owner due to a missing Product Owner. Although they understand the system / product into detail, this isn’t a good idea. For analysts models / documentation are their primary artifact and often also single point of truth. This often results in the diagrams being the master over the backlog, which results in too many documentation and other challenges.
Old habit: communicating via documentation
(Where Do Product Owners Come From? | http://www.agilemodeling.com/essays/productOwner.htm )
Trigger: diagram first, too much documentation.
End user as Product Owner:
The end user knows what he wants, but this doesn’t make him immediately a good Product Owner. A Product Owner needs to be available for the team all the time and needs to make visionary decisions with technical knowledge, something an end-users can miss during their daily work.
Trigger: missing in action Product Owner, Scope Creep.
Scrum master as Product Owner:
Problems may arise when the PO is being pulled by the customer in one direction that is causing significant strife to the developers (because they need to build some other infrastructure first). The SM job is not to follow the whims of the customer but to protect the developers from their whims. Pulling this off objectively is hard.
(#in comment: In Scrum, why shouldn't the Product Owner and ScrumMaster roles be combined? | http://programmers.stackexchange.com/questions/106966/in-scrum-why-shouldnt-the-product-owner-and-scrummaster-roles-be-combined )
The Product Owner cannot be the Scrum Master. They both have clear interests and habits. Changing their individual habits is hard. Changing them so they can see both points of view is impossible. They first have to learn the new way of doing their job with agility.
(Product Owners not proxies | http://kenschwaber.wordpress.com/2011/01/31/product-owners-not-proxies/)
Trigger: sprint interference.
What are the most common problems with Product Owners?
There is a big list of common Product Owner problems, for example when he is not available or that he doesn’t have the power to make decisions, or … see below a list of blog posts which covers them.
AVOIDING COMMON PRODUCT OWNER MISTAKES | http://www.romanpichler.com/blog/roles/avoiding-common-product-owner-mistake/
Product Ownership Antipatterns, or a character description of the PO from Hell | http://agile.dzone.com/articles/product-ownership-practice
Open Space Notes: Building a Better Product Owner | http://www.scrumalliance.org/resources/357
Your Product Owner Is Missing in Action — Now What? | http://www.scrumalliance.org/articles/509-your-product-owner-is-missing-in-action--now-what
Product owner training
Professional Scrum Product Owner Training | http://www.scrum.nl/training/Professional-Scrum-Product-Owner-Training-110224
CSPO: An Introductory Course for Product Owners | http://www.scrumalliance.org/pages/certified_scrum_product_owner