Get together and introduce a big open source project Expression2sql

I. Introduction of EXPRESSION2SQL

Expression2sql is an open source project that can parse expression trees into Transact-SQL. Easy to use, a few minutes to get started, because bloggers in the design expression2sql as much as possible according to the syntax of the Transact-SQL style design, as long as the caller familiar with the basic Transact-SQL syntax can be quickly open code, Greatly reduced the cost of learning Expression2sql, even 0 of the cost. Object-type operation, chained programming, arbitrary assembly of SQL, automatic generation of table aliases, parameterized assignment, preventing SQL injection, supporting multiple databases, generating extremely beautiful SQL strings (formatting), advantages A, merit B, advantages C, advantages ... Still waiting for you to find it! O (∩_∩) o~

Because the insert operation is basically pure reflection, it is difficult to hook up with the expression rime, so there is no way to insert operations. Expression2sql's first version of the current release is 1.0, so the function is not perfect, can only do some simple expression tree parsing into SQL operations. Later bloggers will continue to update the maintenance, so that expression2sql gradually improved.

Since Expression2sql's responsibilities are very simple, it is purely an input expression tree, and after its parsing, it can return to Transact-SQL to the caller. So its usage scenario is mainly used for docking with third-party ORM or native dbhelper based on ADO, enabling it to support object-and expression-tree chained programming.

Expression2sql Source Managed Address: HTTPS://GITHUB.COM/STRANGECITY/EXPRESSION2SQL

Many open source projects included: http://www.cnblogs.com/StrangeCity/p/OpenSourceProject.html

The boom-and-go yy for so long, then the next Bo will show an illustrated way to illustrate the use of expression2sql examples.

Second, single-table simple query

Third, where conditions

3.1. Where like

3.2. Where in

3.3. Multiple Where condition combinations

Four, multi-table association query

4.1. Join

4.2. INNER JOIN

4.3. Left Join

4.4. Right Join

4.5. Full Join

4.6, Multi-table Complex Association query

V. GROUP BY

Vi. ORDER BY

Seven, function

Viii. Delete Deletes

IX. Update Updates

Ten, Ctrip Recruitment

Ctrip in hand, said go away

Ctrip Shenzhen luohu Old Street subway station five days eight hours (flexible), weekend double off all kinds of benefits + subsidies + Five insurance one gold + months of the year-end award, monthly salary at least 10K start

. NET Engineer

Job Responsibilities:

Develop a strong service to suit the fast growth of your business, and programs for apps, Online, Offline, Windows service calls, to be able to adapt to lbs. Development of offline system for offline and hotline personnel booking, order Processing, reporting purposes.

Job Requirements:

1. Computer related major, at least three years working experience in development.

2. Familiar with. NET partial namespaces or related technologies (WCF, MSMQ, MVC, Entity Framework, Linq, Session, Cache, Route, Rewriter, RESTAPI, etc.).

3. Familiar with SQL Server, MySQL database, learn about SQLite, Oracle, etc., have a certain database design capabilities, according to the application scenario, reasonable planning read and write frequency and storage structure, NoSQL storage System experience is the best.

4. Familiar with the basic knowledge and tools of Web design (HTML, JS, JQuery, CSS, JSON, XML, Gzip, fiddler, regular, etc.).

5. Familiar with common software architecture, design patterns, object-oriented, skilled use of UML modeling.

6. Familiar with performance tuning, can continue to improve, and have their own complete mature insights.

7. Able to adapt to changes in business and technology, independently or in collaboration with working partners to analyze and solve technical problems, to provide innovative solutions.

8. Have good document ability and good coding style, actively participate in code review.

9. Strong communication skills, good teamwork spirit, sense of responsibility, passion, willing to share, can keep improving, admit that technology is very cow.

Web Front End Engineer

Job Requirements:

1. Computer related major, at least three years working experience in development.

2. Familiar with all kinds of web front-end development technology, including JavaScript, Ajax, Css, HTML5 and other web development areas related technologies;

3. Familiar with the object model, familiar with jquery, familiar with the HTTP protocol;

4. Continue to focus on new technologies in the industry and study one or more of the frameworks of jquery, Bootstrap, zepto, etc.;

5. The front-end object-oriented, MVC (Backbone, Ember, AngularJS), modular development (Amd\cmd:seajs Requirejs), has a certain development experience;

6. Familiar with website performance optimization, technology experience optimization, web-compliant site reconfiguration has extensive experience.

6. Familiar with performance tuning, can continue to improve, and have their own complete mature insights.

7. Able to adapt to changes in business and technology, independently or in collaboration with working partners to analyze and solve technical problems, to provide innovative solutions.

8. Have good document ability and good coding style, actively participate in code review.

9. Strong communication skills, good teamwork spirit, sense of responsibility, passion, willing to share, can keep improving, admit that technology is very cow.

10. Mobile Project development experience is preferred.

Plus 1: The fundamentals are solid, and using a solid foundation can quickly learn new technologies and be able to extrapolate.

Add 2: There is a certain degree of technical foresight and the overall view of the large system of service and client have a certain understanding.

Add 3: Good logical thinking, communication skills, expression skills. To be humble and studious, to work conscientiously and responsibly.

The most central priority: the ability to continuously follow up on issues, analyze them, and ultimately solve problems efficiently.

Blog Park Elegant , master such as cloud, Crouching Tiger Hidden Dragon, talents, so put a recruitment information, hope to Ctrip interested students can visit, come to abuse a abuse interview officer ^_^

Interested students please send your resume to Blogger's email address: [Email protected]

Get together and introduce a big open source project Expression2sql