JParrish:L2S does a good job of generating a series of classes from the database, but the object model that you get is a one to one rendition of the physical model.
The problem here is that L2S doesn't really support anything other than a one-to-one mapping. That is, it has nothing like the Entity Framework's ComplexType. ComplexType would have been useful for modeling absorbed entity types. While it's possible to fake-up complex types using custom property types (see http://dotnetslackers.com/articles/csharp/Complex-Types-in-LINQ-to-SQL-Reloaded.aspx, you lose automatic change tracking. I think this problem can possibly be addressed, by changing the custom property object constructor so it has a reference to the object into which it's absorbed (and so can report changes), but I haven't tried that. It depends on whether you can get sufficient control of the object instantiation layer which calls the constructor.
You also don't get an identity map for the complex types, so if a query for Customers yields two records that absorb the same Address, you get two Address objects, not one. That's because L2S only uses a primary key identifier field to address its identity map, not (as in the case of an absorbed Address) all fields.
Another way to handle it would be to handle the absorbed entity as a C# struct, and I think it would be possible to get proper change tracking that way, though you still wouldn't have an identity map for the entity.
JParrish: Are there any extensions to NORMA that generate C# object models
ActiveFacts generates an object model from either CQL or NORMA. Currently, there is no L2S (or other C#) generator. I've just been looking at what it would take to build one however. How much do you want one? :)