<div>
Thank you, but I find this limitation stupid :s
</div>


Thank you, but I find this limitation stupid :s

<div>
You could execute an SQL comment directly by using the connection of the ObjectContext but it must be a correctly formed SQL syntax because the command is not checked at compile time but only at run-time.<br />
<br />
ObjectContextInstance.Exec<wbr />uteStoreCo<wbr />mmand(&quot;SQL<wbr /> Statemens as a string&quot;, params Object[] parameters);<br />
<br />
Documentation ObjectContext.ExecuteStore<wbr />Command Method :<br />
<a href="http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.executestorecommand.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.executestorecommand.aspx</a><br />
<br />

</div>


You could execute an SQL comment directly by using the connection of the ObjectContext but it must be a correctly formed SQL syntax because the command is not checked at compile time but only at run-time.

ObjectContextInstance.ExecuteStoreCommand("SQL Statemens as a string", params Object[] parameters);

Documentation ObjectContext.ExecuteStoreCommand Method :
http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.executestorecommand.aspx [http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.executestorecommand.aspx]



<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
I only want to know if this is possible to delete, with Entity Framework 4.0 some objects directly by specifying conditions.<br />
<br />
I know I can select all object and then do a foreach on them and delete them. the goal is to avoid to retrieve data only to delete them. So please don't provide me a solution like <br />
<br />
foreach( MyObjectType myObject in DataContext.MyObjectType.W<wbr />here( &lt;conditionsHere&gt;))<br />
&nbsp; &nbsp;DataContext.MyObjectType.D<wbr />eleteObjec<wbr />t(myObject<wbr />);<br />
myObject.SaveChanges();<br />
<br />
The goal is to have something like:<br />
<br />
DataContext.MyObjectType.D<wbr />elete.Wher<wbr />e(m=&gt; m.date&lt;= someOtherDate);
</div>
</div>


Hi!

I only want to know if this is possible to delete, with Entity Framework 4.0 some objects directly by specifying conditions.

I know I can select all object and then do a foreach on them and delete them. the goal is to avoid to retrieve data only to delete them. So please don't provide me a solution like 

foreach( MyObjectType myObject in DataContext.MyObjectType.Where( <conditionsHere>))
   DataContext.MyObjectType.DeleteObject(myObject);
myObject.SaveChanges();

The goal is to have something like:

DataContext.MyObjectType.Delete.Where(m=> m.date<= someOtherDate);

Entity framework: Delete objects  that respects some conditions

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).