c# - How to choose a data access method in ASP.NET MVC? -


I was programming in C # 2.0 WinForms for a while i wasp.net and new MVC frameworks and C # 3.5 I am starting to get involved in the new features. I have only read a little on LINQ from LINQ, but some test app has tried to do this in my WinForms app, I usually have some kind of data access layer, and all myself have been written SQL, of course, if anything is for me CRUD So, I am doing everything for this.

I looked at the tutorial on the www.asp.net/mvc website and both example framework and LINQ did the SQL example for example, they both look very similar. LINQ looks more like SQL, but the unit framework looks more like a C #.

My questions are:

  1. Is one method better than another?
  2. What are the advantages of one over the other?
  3. Can SQL be seen, which comes when using any of the methods?
  4. Since I am new to ASP, are web developers leaning on one side? LINQ-to-SQL Simple (but still well engineered)

  • Only LINQ-to-SQL works on SQL Server (unit framework is plug-in; Third party
  • Entity framework data (storage) model and object Supports more separation between models - LINQ-to-SQL is a literal table / column =>
  • LINQ-to-SQL is actually "full" in the stuff does :
    • UD FS does not support EF
    • EF sub-expressions (such as custom expression for trees) do not support like EF does not support some "clear" methods such as single ()
    • EF does not have some TSQL optimizations, which are called LINQ-to-SQL

Originally the EF moment is slightly more of a "v1" (or even "v0.9") product . However (and more importantly) - EF.NET 4.0 etc. is likely to be a suitable next version where as long as the LINQ-to-SQL view It's gonna change As the following major product Microsoft (rather than the two products to co-develop each other). You should think about long-term plans.

Right now, but EF is in the long run ... So I'm using a repository, etc. to hide some awesome implementation details - one bit leakage repository

3: With LINQ-to-SQL, assign TextReader to dataContext.log ; Console.Out works well - or I have one that writes to trace.asax. With EF.

4: I suspect that this complexity breaks a lot. People using SQL Server with a simple model, or are happy for a storage model that shines in the object model, currently use LINQ-to-SQL (which I see). People with more complexity and other databases use NHibernate; -P and then some EFs I am thinking that when EF is released in the next NIT 4.0 then how much will it change ...


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more