Yesterday I accidentally discovered that you can edit a multiplicity end point in the EDM Designer:
It’s a known bug and is fixed already (post-RC). The changes don’t get saved with the EDMX.
Monthly Archives: March 2010
March 24 VTSQL Meeting: BI with SQL Server guru Rushabh Mehta
When: March 24th, 6PM
Where: Competitive Computing, Colchester Vermont (www.competitive.com)
From Zero to BI in 10 Minutes or less
By Rushabh Mehta
Finally a technology that the Information Worker can use to take raw data and turn it into valuable information in a matter of minutes from the comfort of their own desktop! In this very exciting and interactive session full of exciting demos, we will walk you through taking raw information from a variety of sources and building a powerful analytical model that can then be used for deep analysis and reporting. We will further see how this set of technologies revolving around the Office 2010 platform and SQL Server 2008 R2 will transform the way information workers will become self-sufficient with their ad-hoc BI and reporting needs.
If you are an information worker, a data junkie, a BI wannabie, want to see some amazing advancements in the Microsoft SQL Server technology stack or just spend an evening and have dinner with us then plan to attend this incredible session.
Rushabh Mehta is the President of PASS (The Professional Association for SQL Server), a leading BI expert working with Solid Quality Mentors and also the Managing Director for Solid Quality India P.L. Rushabh has been architecting and implementing large and complex Business Intelligence solutions for organization like Raymond James, Microsoft, US Department of Defense, Jackson Hewitt and many more for over 10 years. He has also developed a number of industry best practices in Business Intelligence arena. Rushabh has also written multiple advanced training courses in Business Intelligence and to date has delivered over 4000 hours of advanced classroom training to over 250 organizations around the world. Rushabh has also mentored a large number of BI professionals around the world, providing them the know-how to successfully build BI solutions for their organizations. Rushabh speaks regularly at large conferences such as PASS, Tech Ed and many others around the world and can frequently be found speaking at some local user group during his travels. Rushabh is also a recipient of the Microsoft Most Valuable Professional (MVP) award in the SQL Server competency consecutively for the past 4 years and was recently a contributing author for a book on SQL Server Integration Services 2008 (Problem-Design-Solution) where he wrote a chapter outlining a solution for building a scale-out ETL process with SSIS based on work he did at Microsoft for building the analytical platform for Windows Azure.
About Solid Quality Mentors
Founded in 2002, Solid Quality Mentors is comprised of over 100 of the leading experts in over 10 active subsidiaries around the world, specializing on Microsoft Data Platform and providing advanced and custom training, mentoring and expert consulting services. Our customers include Microsoft, AT&T, Associated Press, Alcoa Howmet, BBC, Capital One, Career Builder, Concord Group Insurance, Conoco Phillips, Georgia Pacific, Harris Interactive, Jackson Hewitt, Lockheed Martin, Mitsui Sumitomo Insurance, Premier Bankcard, Progressive Insurance, Raymond James, USDA, US Veterans Health Administration, US Department of Defense, Zillow.com and many more. You can find more information at www.solidq.com or contact us at info@solidq.com.
Two Introductory VS2010 Entity Framework Videos on Pluralsight on Demand
These are the first two. I’ve got more coming!
If you don’t have a Pluralsight subscription, grab a free guest pass and you’ll have have access since these are part of the subset of guest pass content along with a ton of other great videos.
These will also be on MSDN online shortly.
If timestamp is deprecated, why do none of the current db tools support rowversion?
Perhaps the title of this blog post will suffice, but I just wanted to highlight this problem.
If you were to look up the timestamp data type in the SQL Server 2008 documentation, this is waht you will find within the topic article:
“The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.”
It’s been there for quite some time.
The functionality of rowversion and timestamp are the same. It’s just a name change to align with the rest of the world and end the confusion caused by the word “time” in the name.
So let’s say you are good at following these types of recommendations and as you create a new table in SQL Server Managmenet studio, you attempt to use rowversion rather than timestamp.
Here’s what you’ll see:
rowversion is not an option.
It’s also not an option if you try to use the column’s properties window.
You can use TSQL to create the column:
ALTER TABLE dbo.Address ADD RowVersion rowversion
But the designer will still display it as a timestamp. The object explorer also says its a timestamp.
What about Visual Studio 2010?
The server explorer doesn’t grok rowversion either and shows the field as a timestamp.
And finally, the tool I use frequently, the Entity Data Model designer also does not recognize rowversion.
If I create an entity from this table, the store schema’s representation of the field is:
<Property Name="RowVersion" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed" />
I can change this manually and it is valid within the schema.
I’m confused. Microsoft wants us to use rowversion but they sure don’t make it easy!
Again, timestamp and rowversion do exactly the same thing. This is only a “decorative” change.
Yet, I care a lot about this because I use timestamp fields in the sample database for my book, Programming Entity Framework. The term “timestamp” shows up in many screenshots and I discuss it frequently throughout the book. I am considering taking on the task of changing every visual and textual reference to rowversion to be in line with Microsoft’s recommendations. Bt if it’s not easy for users to use the rowversion type, I’m very hesitant to force it on them.
Vermont IT Jobs: Burlington based Microsoft Gold Partner looking for .NET Devs
Software Engineers
Competitive Computing, aka C2, is seeking Software Engineers to design, architect, and maintain .NET applications to support our clients’ eCommerce business requirements. The successful candidates will create high-quality ASP.NET web and eCommerce sites using web-based tools and techniques. Experience with languages including C#, VB.NET, ASP.NET, and JavaScript are a must. The ideal candidate will have a thorough understanding of internet and database architecture, and a high level of technical expertise in web development.
Key responsibilities include:
• Contribute individually to the design, architecture, and development of large-scale custom application development projects
• Interact with internal technical, business and management staff, as well as clients
• Work in a team environment to develop web portals and ASP.NET applications for major client projects
• Establish, support, and evolve C2 development and process standards within all projects
• Review code of other developers while applying strict adherence to quality standards and control points
• Interface with Program Managers, Project Managers/Analysts, Creative/UI Designers and clients
• Keep current with technology trends and industry developments
Qualifications
• Three+ years of experience in .NET development of eCommerce solutions
• Experience with ASP.NET (C# or VB.NET) using the Visual Studio development environment, SQL Server 2000/2005, XHTML, XML, Windows 2k and 2k8 Server and Internet Information Server (IIS)
• Strong foundation in the concepts of web-based application development
• Strong understanding of the SDLC
• Client-side development in JavaScript and a comfort with Object-oriented development methods
• Experience with eCommerce development
• Experience in Content Management Systems (i.e. Sitecore)
• Experience in one or more of the following technologies: MS Commerce Server, Content Management Systems, AJAX, jQuery
• Experience with standards-compliant HTML development using Cascading Style Sheets (CSS)
• Professional service experience
• Creative, flexible self-starter with a strong desire to learn
• Team- and solutions-oriented
• Bachelor’s degree in a related field
• Technical certifications a plus
Competitive Computing offers a comprehensive benefit package and is an equal opportunity employer. Interested applicants should send a cover letter and resume to: jobs@competitive.com