How To: Model Inheritance in Databases

30 בספטמבר 2007

How To: Model Inheritance in Databases Playing with some Object Relational Mapping technologies these days such as Linq to SQL and ADO.Net Entity Framework, one of the capabilities that is important to check is which strategies of inheritance modeling is supported by each technology. This post talks about how to model inheritance in the database, regardless the technology that we will use later to talk to the database. Assuming that the business entities look somewhat similar to this:   There are three common strategies of modeling this class hierarchy in the database: Table per Class Hierarchy This strategy means that all the class hierarchy...

Web Service Software Factory Modeling Edition Roadmap

29 בספטמבר 2007

Web Service Software Factory Modeling Edition Roadmap Don Smith has published the September Drop of the new Web Service Software Factory Modeling Edition (formerly known as Service Factory v3). This drop contains only a newer version of the Service Factory Documentation, and can be found here. Along with this drop, Don has updated the roadmap page for this software factory. Here are the highlights from this page: The final community release of the Web Service Software Factory Modeling Edition is planned for October 30th, 2007. This release contains the Service Contract Designer, Data Contract Designer and Host Designer. The WSDL Import...

Linq to SQL Xml Based Mapping

27 בספטמבר 2007

In the last post I talked about Linq to SQL Attribute Based Mapping that lets you map CLR Objects to database objects using attributes. Although this approach is very simple and easy, it is compiled with the code and cannot be changed without recompiling. Another approach is Linq to SQL Xml Based Mapping that maps entities to database objects according to an xml file that is loaded in runtime. So, given the two entities from the previous post, that have no mapping attributes at all: class Order {     public int Id { get; set; }  ...

Linq to SQL Attribute Based Mapping

23 בספטמבר 2007

Linq to SQL Attribute Based Mapping Linq to SQL has two mapping sources to map entities to tables in the database: Xml Mapping Source and Attribute Mapping Source. Developers use the graphic Object Relational Designer to design a model, and Visual Studio generates the code of the entities along with the attributes with mapping information. In order to understand the mapping capabilities and how it works, I decided to start from an empty project, and create some entities without using the designer at all. This post is a step by step walkthrough of what I did in order...

Astoria September 2007 CTP for Visual Studio 2008 Beta 2 is available

18 בספטמבר 2007

Astoria September 2007 CTP for Visual Studio 2008 Beta 2 is available After the release of Visual Studio 2008 Beta 2, and the release of the ADO.Net Entity Framework Beta 2, here comes the new CTP of Project "Astoria" that works with it. If you are not familiar with Astoria - it's goal is to enable applications to expose data as a data service that can be consumed by web clients within a corporate network and across the internet. The data service is reachable over HTTP, and URIs are used to identify the various pieces of information available through the service....

Create Facebook Application with Microsoft Technologies

Facebook is another social network that allows you to connect to people around you, and be in touch with them. Recently, Microsoft has launched a partnership with Facebook which allows developers to create Facebook applications with Microsoft technologies such as Windows Forms, ASP.Net and Popfly. To get started, download the Download the Facebook Developer Toolkit and see the QuickStarts. Read more about the partnership and the toolkit here.
5 comments

הוספת קוד לפוסטים – איך לעשות את זה נכון

3 בספטמבר 2007

הוספת קוד לפוסטים - איך לעשות את זה נכון פוסט זה הוא פוסט המשך בסדרה "טיפים וטריקים: כתיבת פוסטים באתר הבלוגים". באפריל האחרון פיסרמתי את הפוסט אליה וקוד בה... המדבר על הוספת קטעי קוד לפוסטים ע"י שימוש ב- Windows Live Writer. מאז השתנו מספר דברים, יצאה גירסא חדשה של Windows Live Writer וגם גירסא חדשה של Visual Studio, ולכן החלטתי לכתוב על הנושא פעם נוספת. כאשר מנסים לעשות Copy & Paste של קטע קוד מתוך Visual Studio לפוסט ב- WLW, זה יראה ככה: static void Main(){    Application.EnableVisualStyles();    Application.SetCompatibleTextRenderingDefault(false);    Application.Run(new Form1());} כלומר ללא הפורמט (צבעים + סוג פונט) שהופכים את קוד לקריא עבור מפתחים. על מנת להעתיק...