Some developers don't start using doctrine in their application just because they find it a little difficult to get started(I listened so from some of my own friends too). And unluckily, I also faced some similar issues as well. I tried to start it at a very early time when I was new in LAMP(Linux, Apache, MySQL And PHP Environment) and found it a little difficult to understand … [Read more...] about Basics On Doctrine CRUD Operations
Database
Using SQL JOIN Operation In LinQ/C#
Being LinQ an Object Relational Mapper, We can avoid writing sql query in many cases. Where its needed to be written even for simple purpose, we can achieve what we need just by calling linq provided methods with proper parameters.This facilitates to make the code more meaningful and less buggy. Join operations are done in sql for retrieve data from a complex relationship … [Read more...] about Using SQL JOIN Operation In LinQ/C#
LinQ Query With Like Operator
Linq To SQL makes a developer's life easy for performing various database operations. If the database design is stable, LinQ To SQL will do all the jobs for you for maintaining consistency between data relations. Simple data retrieval, insertion, deletion, update, etc can be done in a very easy way, in some cases just by calling some functions on the LinQ objects. There are a … [Read more...] about LinQ Query With Like Operator
LinQ To SQL Database Update Operations In C#
Recently, I have discussed getting started linq to sql in c#.net. The articles also covered creating select queries for retrieving both single and multiple results. Today, in this tutorial, I will try to give some more examples of other types of database operations, that write/updates the database. These will cover writing and executing 'Update'/'Insert'/'Delete' query in the … [Read more...] about LinQ To SQL Database Update Operations In C#
Beginning LinQ To SQL In C#.NET
Here, I will discuss a basic LinQ to SQL tutorial overview, then how to get started very quickly with its usage on our C#.NET-based applications(This can be used in desktop and web applications in the same way). Besides, I will also discuss using 'select' query in LINQ to retrieve data and traverse through the query results(in case of multiple result objects). To understand … [Read more...] about Beginning LinQ To SQL In C#.NET