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

MySql variables and php -

-
I am getting an error with php in order to format mysql_query () in php to format this string What is the right way? SELECT SELECT SELECT (*) Agents @AgentCount; User_Agent_English, User_Angent_Oursal, US.___Gent_Aginal, COUNT (User_Agent_Percade) ACC, COUNT (*) / (AgentCount) Percentage by agents user_agent_preser order DEC limit limit 50; In PHP, how am i setting $ query $ query = "SELECT count (*) agents @ agentcount; SELECT user_agent_parsed, User_agent_original , COUNT (user_agent_parsed) ascount, COUNT (*) / (@AgentCount) as a percentage by user_agent_parced by URI date DESC limit 50 "; This exact query will work properly if I put it in MySQL directly through a command line session. Do I need to release two separate php calls from mysql_query () and store the results first? I get the following error: There is an error in your SQL syntax; Instead of using a sub-selection and instead of using the 'SELECT user_agent_parsed, user_agent_original, ne...
Read more

url rewriting - How to implement the returnurl like SO in PHP? -

-
This URL should work even after the rewrite. Is this possible? Otherwise, I can only hardcoded everything If you are trying to create a login system with redirection You need to use the HTTP_REFERER header to find out where the user came from so that you can send it back there. The best way to do this is to use something like this in your login form: // - Login php & Lt; Input type = "password" name = "password" /> & Lt; Input type = "hidden" name = "returnrelale" value = "& lt ;? php echo $ redirectURL ;? & gt;" / & Gt; & Lt; / Form & gt; Please note that some ISP, browser or proxy will delete the referrer header, so you can not rely on each user to work fully. If you use a statement, to check whether the header exists or not, you can send those users back to the homepage or whatever. Edit If you are looking to use $ _SERVER ['REQUEST_URI'], if you are running Apache It sho...
Read more

Which Python client library should I use for CouchdB? -

-
I am starting to experiment with CouchDB because it looks like we have the right solution to certain problems That all the work will be on a new project, which does not have any legacy dependency, which the client library will suggest you use, and why? If we overlap any of the OS. Freeband is available only in the collection of its ports, but asks to use the library's project website. None of those people are Ubuntu, which is only with ships, since those two OSAs are not common in libraries, I am probably installing something from source (and hopefully if I have time, then Ubuntu and FreeBSD People pack the package). For those interests, I want to use CouchDB as a convenient intermediate storage space for data passed between different services - think of a message bus system, but less formalities with. For example, we have daemons that download and pars the web page, then send an interesting bit to other daemons for further processing. Many of them are ill-defined until the...
Read more