ASP.NET MVC open source application. MySQL or SQL Server? -

-

I have around 4 years of ASP.NET experience; I have a little knowledge about Ruby on the SQL Server (Web form only) Rail and I have applied a very small 2-3 pages in my work at ASP.NET MVC. Now I and my friend (Experiences like me) are ready to gain more experience of ASP.Net MVC. For that purpose we have thought about the development of an open source application in ASP.NET MVC. It can be a blog system or forum or something else so that the community can take advantage of it. But we can not decide back-end database for applications between MySQL and SQL Server. What would you suggest in relation to the following -

  1. Which will be more supportive or will it be required by the community?
  2. If we use MySQL, will it be difficult to proceed?
  3. Is there a chance to support both by using the ORM (I have no experience working with any ORM)
  4. Any other suggestions?

Thanks in advance.

Will the community be more supported or needed?

For most business users and the most dedicated ASP hosting provider, this will be the Microsoft SQL Server IMHO. Surprised in version numbers spread. I see a lot of SQL Server 2008, a lot of 2005, and very surprisingly even in 2000.

"We are cheap, is it free for small?" Businesses and individuals, I also see some MySQL on Windows. I think the companies I have worked with, in my small cycle, this is 2/3 MSSQL and 1/3 SEL, which are two databases told to you.

If we use MySQL, can it be difficult to proceed?

In the case of more difficult development? Yes and no; SQL is more or less than Linux, which is available only for MSSQL, and many people get a simple and natural technology to do this work. So "yes" if your plan was to use SQL from LINQ as the ORM of choice, like other good organizations, NHibernate works equally well with both databases, as is called Big_George.

Is there a chance to support both using the ORM (I have no experience working with any ORM)

Sure , Fx

Any other suggestions?

Since this is your first application, so first the Macpops and Amp; See prototyping, UML or anything else of your choice whether you can criticize some of the experienced MVC developers for their designs, but do not take their criticism as a Gospel, there is more than one way to work properly.

Obviously consider the suggestion of Tianfosan to use the IRAP facility to provide flexibility on the storage layer.

Consider using unit testing and dependency injections from the beginning; Both IMHOs are very important and helpful in the long run. On the negative side, if you do not have prior experience with this then it will be a very new technology.


Comments

Post a Comment

Popular posts from this blog

asp.net - Javascript/DOM Why is does my form not support submit()? -

-
This is my first time working with asp.net and javascript, so I do not know very good web resources, or Much about javascript debugging I have to find out that on line oFormObject.submit (); Microsoft JScript Runtime Error: Object does not support this property or method I am using the link to work as a button because I am terrible in aesthetics and I think That link will look more professional than a table of 50 buttons. I have read that this solution can cause problems with browsers due to pre-rendering of my links and many additional traffic and problems, but CSS gives me a button like a link, which has issues of alignment and difference seemed to. & lt ;! DOCTYPE HTML PUBLIC "- // W3C // DTD HTML 4.01 // N" "http://www.w3.org/TR/html4/strict.dtd"> & Lt; Html xmlns = "http://www.w3.org/1999/xhtml" & gt; & Lt; Head & gt; & Lt; Link rel = "stylesheet" type = "text / css" href = "defect differen
Read more

sockets - Delphi: TTcpServer, connection reset when reading -

-
I am trying to implement one for Delphi, but there are some problems with communication. Fitnesse will start my process, and give me a portmember as a command line argument. Then I should make a socket on the port number given to me, and fitness will connect to that port I am using a TCPCP server for the job: < Pre> TcpServer1.LocalPort: = ParamStr (ParamCount); TcpServer1 Active: = true; On OnEXEPT () -Event, I send the protocol version to use as specified in the protocol. Process TForm1.TcpServer1Accept (From: TOBject; ClientSocket: TCustomIpClient); Var s: ansistring; Start clientSocket. Syndrome ('slim - v 0.0', # 10); SetLength (S, 6); ClientSketts Receavebook (S, 6); End; When I call ReceiveBuf (), the process ends, and fitness throws an exception: java.net.SocketException: connection Reset I have seen what sent and received. It shows that my code sends the protocol version, fitness sends back a message, and when I try to get this message
Read more

javascript - Classic ASP "ExecuteGlobal" statement acting differently on two servers -

-
I have a strange problem that I really do not know. In addition to developing a new ASP.NET site, I have to support the old "classic ASP" site. It is written in VBScript with a batch of JavaScript functions. Many of the JavaScript functions include 'files' Everything is fine on our production system (which security is controlled by another group - this is a military installation) Debugging them once did not work I). However, I have a fix for a vague bug that needs to be fully tested and some functions do not run under the "local" copy of the website that runs on my PC. For the record, I am running IIS 5.1 on XP. The problem is that some Javascript functions are running "OK" on the production server, but when they use it as a server, they are not defined on my PC what is happening that last Programmer, for some reason, has decided to put some functions in a series of files, which according to the observations, imitate the "need_once
Read more