Some developers don't start using doctrine in their applications just because they find it a little difficult to get started(I heard from some of my friends, too). Unfortunately, I also faced some similar issues. I tried to start it very early when I was new in LAMP(Linux, Apache, MySQL And PHP Environment) and found it a little difficult to understand the official … [Read more...] about Doctrine CRUD Operation Basics
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 you need to maintain consistency between data relations. Simple data retrieval, insertion, deletion, update, etc., can be done in a straightforward way, in some cases just by calling some functions on the LinQ objects. Several … [Read more...] about LinQ Query With Like Operator
LinQ To SQL Database Update Operations In C#
Recently, I discussed getting started with 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/update the database. These will cover writing and executing the '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 beginner's LinQ to SQL tutorial overview, then explain 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 the 'select' query in LINQ to retrieve data and traverse through the query results(in case of multiple result objects). … [Read more...] about Beginning LinQ To SQL In C#.NET