It sounds simply as though your model is unaware of the fact that it is an identity; the ID column should be marked as db-generated (Auto Generated Value in the UI, or IsDbGenerated in the xml), and probably as the primary key. Then it will not attempt to insert it, and will update the value … Read more
I’m afraid you’ve indeed seen overly simplified examples. LINQ to SQL (System.Data.Linq) is your DAL layer. The classes L2S generates is your domain (but not to confuse with Domain-Driven Design). On top of that you can still write your Business Layer. I always try to prevent leaking the LINQ to SQL DataContext into the presentation … Read more
You need to disable the Pluralize Table Names for the LINQ to SQL designer. To do this navigate to Tools -> Options -> Database Tools -> O/R Designer and change the Pluralization of names to false. Then you will need to recompile your project and it should address the naming
The MetadataType attribute is used to specify help specify the additional information on the data object. To access the additional attributes you would need to do something like the following: using System; using System.Linq; using System.ComponentModel.DataAnnotations; using System.Reflection; namespace MetaDataTest { class Program { static void Main(string[] args) { MetadataTypeAttribute[] metadataTypes = typeof(MyTestClass).GetCustomAttributes(typeof(MetadataTypeAttribute), true).OfType<MetadataTypeAttribute>().ToArray(); MetadataTypeAttribute … Read more
IMO, not at the moment. It is clear (from recent announcements especially) that EF is in for some heavy revisions as the “thunderdome” scenario plays out between LINQ-to-SQL and EF. Whatever happens, EF (in a few years) will almost certainly look quite different to EF today. Or certainly “different enough” ;-p As such, my view … Read more
This is more like an extension to @Alex’s answer. Step 1 : Set the connection property of your .dbml file to “none”. Step 2 : Create a new separate partial class with the same name as that of the existing partial class for the .dbml file. And set the connectionString property by using the parameterless … Read more
List<string> states = new List<string> { “CA”, “IN”, “MD” }; var q = from a in authors where !states.Contains(a.state) select new { a.au_lname, a.state }; or var q = authors.Where( a => !states.Contains( a.state ) ) .Select( a => new { a.au_lname, a.state } );
You need to import the namespace into your view by adding @using System.Data.Linq at the top of your view. However if you want it in all your views then you need to add <add namespace=”System.Data.Linq” /> to the web.config in your Views folder: <system.web.webPages.razor> <host factoryType=”System.Web.Mvc.MvcWebRazorHostFactory, System.Web.Mvc, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35″ /> <pages pageBaseType=”System.Web.Mvc.WebViewPage”> <namespaces> <add … Read more
Let me preface this by saying that I am a dyed-in-the-wool database guy. As a gross over-generalization: Developers don’t know SQL. Developers don’t really want to know SQL. They can write it, they can design tables, but it makes them feel icky. They tend to do stupid things when the necessary query is more than … Read more
The Double Metaphone algorithm, published in 2000, is a new and improved version of the Soundex algorithm that was patented in 1918. The article has links to Double Metaphone implementations in many languages.