CodeBetter.Com
CodeBetter.Com
RSS 2.0 via Feedburner
           Do you Twitter? Follow us @CodeBetter

Jeff Lynch [MVP]

Everything E-Commerce!

January 2007 - Posts

  • Visual Studio Team Edition for Database Professionals: Case Study Published!

    It seems like just last week that I was installing another CTP of "Data Dude" and playing around with the schema compare and unit test features. It's hard to believe that we've already implemented the RTM version and are using it constantly in our day to day work. What a difference having the right tool makes to your success and enjoyment as a developer.

    Well, the folks at Microsoft have been kind enough to give Gulf Coast Seal some free publicity and have published our "Data Dude" case study. It's kind of strange reading a case study about your own project and looking at what you've said about a new product, but I can tell you this. "Data Dude" really is a tremendous product from Microsoft and one which I truly enjoy using. It's also great to know that this is just the beginning and that Visual Studio Team Edition for Database Professionals will continue to evolve and grow just as the entire Visual Studio Team System does.

    A friend of mine at MSFT once asked me what it would take to get me to upgrade from a regular sku of Visual Studio to Team Suite. "Data Dude" is the answer! My only complaint is that it takes so darn long to type out the name of this product. I could write two sprocs and a unit test faster! (LOL)

    Special thanks to Brian Keller, Matt Nunn, Cameron Skinner, Gert Drapers and the rest of the team (especially Robert Merriman) for listening so well. I look forward to your next TAP!

    Technorati Tags: , ,

  • Commerce Server 2007: The ERP System is King! (Series Post #1)

    If you've read any of my previous Commerce Server posts you'll remember that planning is the key to success and the first step in this planning process is understanding that "the purpose of any e-commerce solution is to fulfill an order". Everything else is just a means to an end. This means that the center of your e-commerce solution MUST be your company's ERP system.

    Keep this guiding principle in mind at all times during your project. All the Commerce Server web site code, SQL stored procedures, BizTalk schemas, maps and orchestrations that you are write are for one simple purpose; to move information in and out of your ERP system so that the ERP system can fulfill your customer's orders.

    Most relatively modern ERP systems provide the necessary APIs to import customer purchase orders and export sales invoices in some format, whether EDI, flat-file, iDoc or xml. Before going any further with your e-commerce project, make sure the folks that manage and program your ERP system are brought on board during the very early stages. Without the support of these people, your e-commerce initiative has little chance to succeed.

    Remember: The Center of your E-Commerce Universe is your ERP System!

    Technorati Tags: , , , ,

  • Commerce Server 2007: B2B E-Commerce is Easy!

    Now that I've got your attention, let me qualify this somewhat by stating that developing a B2B (business-to-business) e-commerce web application is both easier and less costly than developing a B2C (business-to-consumer) web application. This is especially true when your application platform is SQL Server 2005, BizTalk Server 2006 and Commerce Server 2007!

    Take for example the hardware and software requirements. In a B2C scenario, you need to size your hardware for a much larger potential peak load. Remember Amazon.com's first holiday season? You just never know for sure how many "consumers" will hit your site at the same time. Most (if not all) businesses that sell to other businesses already know who their customers are and the numbers range from a few hundred to a few thousand. Purchasing servers to support a few hundred concurrent users (peek load) is much easier and less expensive. Since most businesses will accept orders in a variety of formats (snail-mail, telephone, fax, email and over the web), true 24 x 7 x 365 site availability (and the redundant hardware / software it requires) may not be absolutely necessary, at least not at first. This doesn't mean that you shouldn't buy the best hardware you can afford. It means that generally, this hardware doesn't have to cost tens of thousands of dollars.

    The software costs go right along with the hardware costs. Most medium size businesses can get started in B2B e-commerce by purchasing the "Standard Editions" of SQL Server 2005 (retail: $5,999 per processor), BizTalk Server 2006 (retail: $8,499 per processor) and Commerce Server 2007 (retail: $6,999 per processor), although I always recommend looking closely at Microsoft's volume license agreements to save some money. Developer licenses of all three products are also very inexpensive, so the barrier to get started is very low.

    Development costs are also very reasonable and most medium size businesses with a few knowledgeable .NET developers can put together a B2B web application in a few months. We did our entire e-commerce project with two developers in only four months and we neither of us worked exclusively on the project. It really doesn't take a rocket scientist (I humbly apologize to my friends at NASA) to learn to use SQL Server, BizTalk Server and Commerce Server. All three products are designed to work together seamlessly to provide a robust application development platform (see, I really wasn't asleep during the keynote at TechEd) and all the developer needs to do is write the code that brings everything together!

    Over the next several months, I'll be presenting a new series of posts aimed specifically at how to write a B2B e-commerce application using SQL Server 2005, BizTalk Server 2006 and Commerce Server 2007. I'll start at the beginning (planning your architecture) and then move through the development process step by step. I'll be presenting code samples within each post (which can also be downloaded as a zip file) so that you can try things out for yourself. I'll be linking to many blogs from the BizTalk and Commerce Server communities as well as to some excellent MSFT white papers recently released.

    As always, ping me via this blog with your questions and comments. I'll try my best to get back to you with answers as quickly as possible.

    Technorati Tags: , ,

  • Commerce Server 2007: Developing for B2B Scenarios

    I spent about an hour on the phone earlier this week with a Commerce Server 2007 developer who asked a very basic but vital question... "What do I do if the StarterSite doesn't fit my scenario?"

    First off, the Commerce Server development team has done an excellent job with the new StarterSite. It's a great reference even if it doesn't fit your scenario (such as a strictly B2B site) since it demonstrates some really innovative web techniques and includes some excellent server controls as well. I highly recommend setting up a development instance using the StarterSite, even if you just use it to see how things work in CS2007.

    Secondly, it's really very straight-forward to implement Commerce Server functionality in any ASP.NET 2.0 web application if you understand how the various subsystems (Profiles, Catalog, Orders, Inventory) work together. It also helps to be able to see some sample code so I've put together a list of my old posts to help get you started.

    Please feel free to ping me via my blog if you have any questions, comments or suggestions.

    Commerce Server 2007: Begin with the End in Mind!

    Commerce Server 2007: Development Tip #1 - Returning a User's Catalogs

    Commerce Server 2007: Development Tip #3 - Creating a New User

    Commerce Server 2007: Development Tip #4 - Returning Site Terms

    Commerce Server 2007: Development Tip #5 - Using the RegionCodeDataSet

    Commerce Server 2007: Development Tip #6 - Adding Items to your Basket

    Commerce Server 2007: Development Tip #7 - Using the CatalogItemsDataSet

    Commerce Server 2007: Development Tip #8 - UpmRoleProvider

    Commerce Server 2007: Development Tip #9 - Shipping Addresses

    Commerce Server 2007: Integrating Commerce Server Orders with BizTalk Server

    and there's more to come in future posts...

    Technorati Tags:

  • VPC2007: Erratic Mouse Behavior in RC

    I've spent several hours testing the RC build of VPC2007 and I'm still experiencing erratic mouse behavior where the mouse seems to "skip" (disappear and reappear during movement). In the beta, this was caused by my Intel Centrino 915 chipset (Dell D810 running Vista Ultimate RTM) and several other symptoms were also prevalent including repeating keystrokes. Now it's only the erratic mouse behavior which is a big improvement over the beta. I've tested this on five different virtual machines and this issue exists on every one, but no two are the same. On vm's created by VPC2004 SP1 and upgraded to the latest vm additions, the problem is very mild. On vm's created by the VPC2007 beta, the problem is so bad it makes the vm unusable. On vm's created by the RC, its usable but very annoying. I'm very surprised that the "degree" of erratic mouse behavior is different on each virtual machine. I've submitted this issue (again) on the MSFT Connect site and am awaiting a response from MSFT.

    I'm wondering if this is an isolated issue on my Dell D810 so I'm asking everyone reading this post and testing VPC2007 to post a comment with your experiences. If you have any feedback, please let me know!

    Technorati Tags:

    Posted Jan 04 2007, 06:19 PM by jlynch with 10 comment(s)
    Filed under:
More Posts

This Blog

Syndication